cURL
curl --request GET \ --url https://api.specular.dev/projects/{id}/schema \ --header 'Authorization: Bearer <token>'
{ "tables": [ { "name": "<string>", "columns": [ { "name": "<string>", "type": "<string>", "nullable": true, "default": "<string>" } ], "primaryKey": [ "<string>" ] } ] }
Get the database schema (tables, columns, etc.) for a project’s production database
Bearer authentication with API key (format: Bearer sk_xxx)
Project ID
Database schema
Show child attributes