Get Database Schema
Authentication
Connections
Guard Rails
Server Management
Jira
Organization Management
Reports
User Management
Get Database Schema
Get detailed schema information including tables, views, columns and indexes
GET
/
connections
/
{nameOrID}
/
schemas
curl --request GET \
--url https://use.hoop.dev/api/connections/{nameOrID}/schemas
{
"schemas": [
{
"name": "<string>",
"tables": [
{
"columns": [
{
"name": "<string>",
"nullable": true,
"type": "<string>"
}
],
"name": "<string>"
}
]
}
]
}
Path Parameters
Name or UUID of the connection
Name of the database
Response
200
application/json
OK
The tables of the schema
curl --request GET \
--url https://use.hoop.dev/api/connections/{nameOrID}/schemas
{
"schemas": [
{
"name": "<string>",
"tables": [
{
"columns": [
{
"name": "<string>",
"nullable": true,
"type": "<string>"
}
],
"name": "<string>"
}
]
}
]
}