Skip to main content

List tables

List table names in a project database.

GET /projects/:projectid/databases/:dbid/tables

Authentication​

Send the project API key in the Authorization header, without a Bearer prefix. Requires databases.read for the database in the URL.

Request​

No request body or pagination parameters.

Example​

Use the environment variables from the database overview. Replace example IDs with your own.

curl --include --request GET \
--header "Authorization: ${INTELLECTIBLE_PROJECT_API_KEY}" \
"${INTELLECTIBLE_PUBLIC_API_URL}/projects/${INTELLECTIBLE_PROJECT_ID}/databases/${INTELLECTIBLE_DATABASE_ID}/tables"

Response​

200 OK

{
"tables": [
"customers",
"orders"
]
}

tables is an array of names from the database’s public schema, not table objects. An empty database returns {"tables":[]}. Ordering is not guaranteed.

Use a table name as tblid when reading its schema or reading rows.

See Errors and safe retries for shared failure handling.