> ## Documentation Index > Fetch the complete documentation index at: https://docs.instacloud.com/llms.txt > Use this file to discover all available pages before exploring further. # Get database tables > **Token scope:** `account` · `org` · `project` — read-only tokens allowed. List schemas, tables, columns, and keys (live introspection, never cached). Gated — db.query. May wake a suspended database. ## OpenAPI ````yaml /openapi/project.json get /projects/{projectId}/database/tables openapi: 3.1.0 info: title: InstaCloud API — Project level version: 0.1.0 description: >- Endpoints under `/projects/{projectId}`: branches, services, deploys, secrets, databases, storage, cron, observability, governance. Callable with any token whose binding covers the project. Generated from the platform's own OpenAPI document (https://api.instacloud.com/openapi.json); see the [API overview](/reference/api/overview) for authentication and token scopes. servers: - url: https://api.instacloud.com description: InstaCloud security: - bearerAuth: [] tags: - name: Projects description: Projects inside an organization. - name: Branches description: >- Branch environments of a project: isolated database, storage and compute per branch. - name: Services description: 'Services on a branch: compute, postgres, storage and managed databases.' - name: Deploy description: Deploy an image or a source to a compute service. - name: Compute description: Build output of a compute service. - name: Secrets description: User secrets, service credentials and how they bind into compute env. - name: Database description: Postgres databases, extensions, credentials and ad-hoc SQL. - name: Storage description: Objects in a storage service. - name: Backups description: Database backups and restores. - name: Cron description: Scheduled HTTP calls against a service or an external URL. - name: Observability description: Logs, metrics, deploy events and database insight. - name: Governance description: Per-project agent policy and the approval queue. - name: Audit description: The project's event timeline, including agent-ingested events. - name: Domains description: >- Domains bought through InstaCloud, bring-your-own zones and their DNS records. - name: Billing description: Usage, cycles, invoices and credits. - name: Templates description: Deploy a template into a project. paths: /projects/{projectId}/database/tables: get: tags: - Database summary: Get database tables description: >- **Token scope:** `account` · `org` · `project` — read-only tokens allowed. List schemas, tables, columns, and keys (live introspection, never cached). Gated — db.query. May wake a suspended database. operationId: getDatabaseTables parameters: - schema: type: string in: query name: branch required: false description: Branch name (defaults to the project's default branch) - schema: type: string in: query name: group required: false description: 'postgres service name (default: the sole postgres service)' - schema: type: string in: query name: database required: false description: 'database on the instance (default: the connection-string database)' - schema: format: uuid type: string in: path name: projectId required: true responses: '200': description: Default Response content: application/json: schema: type: object properties: tables: type: array items: type: object properties: schema: type: string name: type: string approxRows: description: pg_class.reltuples estimate — render as "~N rows" type: integer columns: type: array items: type: object properties: name: type: string dataType: type: string default: anyOf: - type: string - type: 'null' identity: type: boolean required: - name - dataType - nullable - default - identity primaryKey: type: array items: type: string foreignKeys: type: array items: type: object properties: name: type: string columns: type: array items: type: string foreignSchema: type: string foreignTable: type: string foreignColumns: type: array items: type: string required: - name - columns - foreignSchema - foreignTable - foreignColumns required: - schema - name - approxRows - columns - primaryKey - foreignKeys required: - tables '202': description: Default Response content: application/json: schema: $ref: '#/components/schemas/ApprovalRequired' '400': description: Default Response content: application/json: schema: $ref: '#/components/schemas/Error' '403': description: Default Response content: application/json: schema: $ref: '#/components/schemas/Error' '404': description: Default Response content: application/json: schema: $ref: '#/components/schemas/Error' '502': description: Default Response content: application/json: schema: $ref: '#/components/schemas/Error' components: schemas: ApprovalRequired: type: object properties: status: type: string enum: - approval_required approvalId: format: uuid type: string action: description: the gated action, or a comma-joined compound set — prefer `actions` type: string actions: description: every capability this approval covers type: array items: type: string message: type: string url: description: the console page where a project admin reviews this request type: string nextActions: type: array items: $ref: '#/components/schemas/NextAction' Error: type: object properties: error: type: string required: - error NextAction: type: object properties: op: description: >- Neutral logical action id, e.g. "service.add" — NOT an operationId or a CLI/MCP tool name; each client maps it to its own surface. type: string reason: description: Natural-language, human/LLM-facing "why do this now". type: string args: description: >- Suggested, flat named arguments; ""s where a value is unknown. type: object additionalProperties: true gated: description: True if the action passes a governance gate. type: boolean required: - op - reason securitySchemes: bearerAuth: type: http scheme: bearer description: Session access JWT or an API token (`insta__`). ````