Semaphor
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.

GET
/api/v1/schemas

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"
}