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^²

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

/*
HTTP GET /users/
@authorize admin, user
@cached
@cache_expires_in 30sec
@timeout 5min
@table_format = excel
@excel_file_name = users.xlsx
*/
select id, name, email, role
from users
where $1 is null or department_id = $1;

SQL File Endpoints Guide →

PostgreSQL Function

sql

create or replace function api.get_users(
  _department_id int
)
returns table (id int, name text, email text, role text)
language sql
begin atomic;
select id, name, email, role
from users
where
  _department_id is null
  or department_id = _department_id;
end;

comment on function api.get_users(int) is '
HTTP GET /users/
@authorize admin, user
@cached
@cache_expires_in 30sec
@timeout 10sec
@retry_strategy aggressive
@rate_limiter_policy authenticated_limit
@tsclient_module = users
';