NpgsqlRestYour SQL is the API

Annotate PostgreSQL functions and SQL files with comments to declare HTTP routes, auth, caching, retries, and rate limits. Get a fast, typed REST API — no controllers, no models, no boilerplate.

Get Started

View on GitHub

~ npgsqlrest

$▌

⚡

Fast & native

AOT executables. 4,500+ req/s on a single host in independent benchmarks.

📝

Declare in SQL

Caching, auth, retries, rate limits — declared as SQL comments next to the query.

🐘

Database-first

PostgreSQL is the architecture — not a detail to abstract away.

🔄

Typed clients

PostgreSQL types generate typed TypeScript clients automatically. No drift.

🔒

Secure by default

Cookies, JWT, OAuth2, conditional caching, per-user limits — built in.

💚

Open source

MIT-licensed. No paid tier, no telemetry, no vendor lock-in.

4,500+

req/s on a single host^¹

production endpoints,
zero C# or Python^²

5×

faster iteration on
signature changes^³

MIT

licensed,
open source

Declare, don't code — caching, auth, retries, rate limiting — all declared as SQL annotations.
PostgreSQL at the center — the opposite of Clean Architecture: the database drives everything.
Types flow outward — PostgreSQL types generate TypeScript clients automatically.
No middle tier — no controllers, no models, no mapping layers, no boilerplate.
Iterate 5× faster — schema is the single source of truth; signature changes propagate to typed clients automatically, and an entire class of type-drift bugs simply cannot happen.
Production-grade by default — response caching, rate limiting, retries, PostgreSQL multi-host failover, load balancing, and Excel/HTML response rendering — configured in JSON, not custom middleware.