peaka_get_project_metadata
Get metadata for all catalogs, schemas, and tables in the Peaka project in a single call. Optionally filter by catalogId and/or schemaName. Use this tool to discover the data structure before writing queries.
Instructions
Get metadata for all catalogs, schemas, and tables in the Peaka project in a single call. Optionally filter by catalogId and/or schemaName. Use this tool to discover the data structure before writing queries.
format makes the result much smaller: "compact" returns { tables: [{ table, desc, columns: [{ name, type, desc, pk, values }], relations }] } with the table names as written in SQL; "ddl" returns CREATE TABLE statements with descriptions as comments. Without format the full stored metadata is returned. includeSamples (with a format) adds distinct sample values to each column.
If you do not already know the projectId for the current task, call peaka_list_projects first and ask the user which project to use. Remember the chosen projectId for subsequent calls in this conversation.Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| format | No | Optional smaller result: "compact" (JSON) or "ddl" (CREATE TABLE text). Omit for the full stored metadata. | |
| catalogId | No | Optional catalog ID to filter metadata by a specific catalog. | |
| projectId | Yes | The Peaka project ID to run against. | |
| schemaName | No | Optional schema name to filter metadata by a specific schema. | |
| includeSamples | No | With format: add distinct sample values of each column. |