Skip to main content

Centia.io

The open PostgreSQL/PostGIS backend for developers who love control

Query your data over HTTP or WebSocket

Use the SQL endpoint or WebSocket to select, insert, update, and delete. Secure by default with OAuth2 and row-level security.

{
"q": "select id, name from rockhall where name = :name",
"params": { "name": "Red Hot Chili Peppers" },
"output_format": "json"
"id": "1"
}

Wrap your SQL statements inside JSON-RPC methods

Create JSON-RPC methods along with optional instructions on how to interpret and format the data types.

{
"jsonrpc": "2.0",
"method": "getFromRockHall",
"params": { "name": "Red Hot Chili Peppers" },
"id": 1
}
SQL APIStylized database cylinder with API brackets

Instant SQL API

Backed by Postgres and exposes a secure, scalable SQL-over-HTTP.

SecurityShield with lock icon

Secure by default

OAuth2, row-level security, and rate limiting baked in — ship with confidence.

Developer FriendlyCode brackets and a small gear

Built for developers

Clean OpenAPI schema, intuitive SDKs, and a friendly CLI to manage your data.