list-schemas
List database schemas with pagination and filtering by fields, database, or inclusion status.
Instructions
List database schemas with pagination
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fields | No | Comma-separated fields to include | |
| limit | No | ||
| before | No | ||
| after | No | ||
| database | No | Filter by database FQN | |
| include | No | non-deleted |
Implementation Reference
- src/tools/schemas.ts:14-16 (handler)The handler function for list-schemas that makes a GET request to /databaseSchemas with pagination and filtering params.
export async function listSchemas(params: z.infer<typeof listSchemasSchema>) { return omClient.get("/databaseSchemas", params); } - src/tools/schemas.ts:5-12 (schema)Zod schema defining input parameters for list-schemas: fields, limit (default 10), before, after, database (FQN filter), include (default non-deleted).
export const listSchemasSchema = z.object({ fields: z.string().optional().describe("Comma-separated fields to include"), limit: z.coerce.number().optional().default(10), before: z.string().optional(), after: z.string().optional(), database: z.string().optional().describe("Filter by database FQN"), include: z.enum(["non-deleted", "deleted", "all"]).optional().default("non-deleted"), }); - src/index.ts:194-194 (registration)Registration of the list-schemas tool on the MCP server with its schema and handler, under the 'core' category.
tool("list-schemas", "List database schemas with pagination", listSchemasSchema.shape, wrapToolHandler(listSchemas));