Skip to main content
POST
Query PostgreSQL

Authorizations

x-api-key
string
header
required

Optional API key for authentication (enabled via application.yaml)

Body

application/json
sql
string
required

SQL SELECT query to execute

Example:

"SELECT * FROM test.stock_price WHERE volume > 1000000"

database
string
default:datris

PostgreSQL database name

limit
integer
default:100

Maximum rows to return. Use -1 for unlimited (no row cap).

Response

Query results

results
object[]
count
integer