NpgsqlRest

Appearance

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¹
74
production endpoints,
zero C# or Python²
12K
lines of SQL
(no host-language code)
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.

Declarative Annotations ​

Declare what you want from your endpoint — caching, authorization, timeouts, retries, rate limiting — right where the SQL lives.

SQL File

~ sql/users.sql
$▌

PostgreSQL Function

~ sql/get_users.sql
$▌

From the Blog ​

NewFeaturedCase Study: 74 Endpoints, Zero Backend Code — A Production App Built Entirely on NpgsqlRestWhat it actually looks like to ship a production application without a controller layer. Real numbers from a finance/visualization app: ~74 HTTP endpoints, 12K LOC of SQL, zero lines of C# or Python, and an estimated 5,000–9,000 LOC of host-language boilerplate eliminated.
From SQL to Type-Safe TypeScriptGenerate typed fetch modules and TypeScript interfaces directly from PostgreSQL functions and SQL files. End-to-end type safety with @tsclient annotations.NpgsqlRest 3.13.0: Cache Profiles, Auth Schemes, Per-User Rate LimitsConditional caching with When rules, short-lived sensitive sessions, per-user rate limiting, and multi-tenant search_path with pgBouncer.PostgreSQL REST API Benchmark 2026Performance comparison of NpgsqlRest vs PostgREST, Django, FastAPI, Spring Boot, Go, Rust, and more — 14 frameworks, identical PostgreSQL functions.Human WrittenSQL REST APIThe story behind NpgsqlRest 3.12.0 — SQL file endpoints, the philosophy of database-first development, and why I think Clean Architecture got it wrong.
Build, Test, Publish and ReleaseLicenseGitHub StarsGitHub ForksCrafted with Claude
❤️ Support this project: Patreon · Buy Me a Coffee
Released under the MIT License.
Copyright © 2024-2026 VB Consulting