{"library":"npgsqlrest","type":"library","category":null,"description":"Automatic REST API server for PostgreSQL databases that generates REST endpoints from database functions, procedures, tables, and views. Version 3.16.3 (current stable) is actively developed with monthly releases. Key differentiators include AOT-compiled native executables for performance (claimed 6x faster than PostgREST), TypeScript client code generation with end-to-end type safety, declarative configuration via SQL comment annotations, and support for authentication (cookie, JWT, OAuth), authorization, caching, rate limiting, SSE, and OpenAPI 3.0 documentation. Unlike PostgREST or Supabase, NpgsqlRest is a Node.js/npm package that bundles a native binary for Windows, macOS, and Linux.","language":"javascript","status":"active","version":"3.16.3","tags":["javascript","postgresql","server","rest","api","automatic"],"last_verified":"Sun Jun 07","install":[{"cmd":"npm install npgsqlrest","imports":["npx npgsqlrest","Generated file like ./src/api/{0}Api.ts (import { publicHelloWorld } from './src/api/publicApi')","Create appsettings.json and run npx npgsqlrest"]},{"cmd":"yarn add npgsqlrest","imports":[]},{"cmd":"pnpm add npgsqlrest","imports":[]}],"homepage":"https://github.com/NpgsqlRest/NpgsqlRest/blob/master/npm/readme.md","github":"https://github.com/NpgsqlRest/NpgsqlRest","docs":null,"changelog":null,"pypi":null,"npm":"npgsqlrest","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}