Discovery
List schemas
Returns the schemas available in a database.
Call this after selecting a connection and database. Not all connection
types use schemas -- for example, MySQL connections go directly from
database to tables. Check the connection's capabilities from
GET /api/v1/connections to
determine whether this step is needed.
Results are filtered by table-level and schema-level security policies on your token.
Authorization
BearerAuth AuthorizationBearer <token>
A project-scoped access token. Generate one via the Token API.
In: header
Query Parameters
connection_id*string
Connection ID returned by
GET /api/v1/connections.
database_name*string
Database or catalog name returned by
GET /api/v1/databases.
Response Body
application/json
application/json
application/json
application/json
application/json
curl -X get "https://semaphor.cloud/api/v1/schemas?connection_id=string&database_name=string"{
"schemas": [
{
"schema_name": "string"
}
],
"sql": "string"
}{
"error": "string"
}{
"error": "string"
}{
"error": "string"
}{
"error": "string"
}