list_templates
Discover pre-built database schema templates for common application patterns like ecommerce, blogs, SaaS platforms, and social networks to accelerate test data generation.
Instructions
List pre-built schema templates for common application patterns.
Available templates:
ecommerce: Customers, products, orders, order items, reviews (5 tables)
blog: Authors, posts, comments, tags, post_tags (5 tables)
saas: Organizations, members, subscriptions, invoices (4 tables)
social: Users, posts, likes, follows, messages (5 tables)
Each template includes realistic field types, proper foreign key relationships, weighted enum distributions, and auto-locale detection via country fields.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Implementation Reference
- packages/mcp/src/tools.ts:296-298 (handler)The handler function for the 'list_templates' tool which calls the underlying template listing function.
function handleListTemplates(): ToolResult { return ok(listTemplates()); } - The actual implementation that returns a list of template summaries from the template registry.
export function listTemplates(): TemplateSummary[] { return Object.values(TEMPLATE_REGISTRY).map( ({ id, name, description, tables, default_counts }) => ({ id, name, description, tables, default_counts, }), ); - packages/mcp/src/tools.ts:368-370 (registration)The registration logic within the main tool switcher in packages/mcp/src/tools.ts.
case "list_templates": return handleListTemplates(); case "generate_from_template":