NpgsqlRestAutomatic PostgreSQL Web Server

Create professional, high-performance HTTP REST APIs for PostgreSQL databases in minutes and generate type-safe client code 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 — Tables, views, and functions 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 PostgreSQL functions into fully-featured REST endpoints.

sql

create function api.get_users(
  _department_id int
  _format text
)
returns setof user_info 
language sql
as $$
select id, name, email, role 
from users 
where _department_id is null or department_id = _department_id;
$$;

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