Connections
Get Database Schema
Authentication
Connections
Guard Rails
Server Management
Jira
Organization Management
Reports
User Management
Connections
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>"
}
]
}
]
}