Chelabase
ManagementSql editor

List your saved SQL queries

GET
/v1/databases/{id}/sql-queries

The caller's saved queries for the database, by name (ignoring case), without their SQL text. Saved queries are private to their author.

Authorization

bearer
AuthorizationBearer <token>

In: header

Path Parameters

id*string

Database id

Formatuuid

Response Body

application/json

application/json

application/json

application/json

application/json

application/json

curl -X GET "https://example.com/v1/databases/497f6eca-6276-4993-bfeb-53cbbbba6f08/sql-queries"
[  {    "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",    "name": "string",    "pg_database": "string",    "role": "string",    "updated_at": "2019-08-24T14:15:22Z",    "version": 0  }]

The schema for the SQL editor's completion GET

Everything the database's owner (or, with `role`, that role) can use in one Postgres database of the branch, read on the same kind of fresh connection a run with that `role` uses, with postgres-language-server's own introspection (the version `PGLS_VERSION` pins), as the JSON its WASM build's `setSchema` takes. Not cached on the server.

Save a SQL query POST

Saves a query for the caller. A user keeps at most 500 per database.