NpgsqlRestAutomatic PostgreSQL Web Server

Create professional, high-performance HTTP REST APIs for PostgreSQL databases in minutes. Write plain SQL files — get REST endpoints automatically.

Get Started

View on GitHub

    _   __                   __  ____            __
   / | / /___  ____ ________/ / / __ \___  _____/ /_
  /  |/ / __ \/ __ `/ ___/ __ \/ /_/ / _ \/ ___/ __/
 / /|  / /_/ / /_/ (__  ) /_/ / _, _/  __(__  ) /_
/_/ |_/ .___/\__, /____/\__, /_/ |_|\___/____/\__/
     /_/    /____/        /_/

⚡

Top Performance, Native Executables, Low Latency

📝

Simple, Declarative Approach with Annotations

🐘

Database First, No N+1 Problems, No Type Mismatch

🔄

Code Generation and End-to-End Type Safety

💚

Free and Open Source, MIT License

NpgsqlRest Architecture - PostgreSQL at the center with automatic REST API, TypeScript generation, authentication, caching, and more

Clean PostgreSQL Architecture - PostgreSQL First Architecture - PostgreSQL Driven Architecture

✓ Schema as contract — SQL files, functions, tables, and views become REST endpoints
✓ SQL comments as config — Routes, auth, caching declared where the logic lives
✓ Types flow outward — PostgreSQL types generate TypeScript clients automatically
✓ No middle tier — No ORM mismatch, no N+1 queries, no boilerplate

Declarative Annotations

Simple comment annotations turn SQL files and PostgreSQL functions into fully-featured REST endpoints.

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;

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
';