v1
latestOpenAPI 3.0.02026-07-1734830.3 KBExecute database operations. Do not use to modify the database schema, use /apis/migrate instead
Execute SQL queries and other database operations
post/v2/query
Request body
Example request
{
"args": {
"source": "default",
"sql": "SELECT column_name, table_name, is_generated, is_identity, identity_generation FROM information_schema.columns where table_schema = 'public';"
}
}Response
Operation executed successfully
Example response
{
"result": [
[
"column_name",
"table_name",
"is_generated",
"is_identity",
"identity_generation"
],
[
"updated_at",
"notes",
"NEVER",
"NO",
"NULL"
],
[
"manager",
"departments",
"NEVER",
"NO",
"NULL"
]
]
}