schema▌

Design and optimize SQL and NoSQL database schemas with normalization, indexing, and migration strategies. \n \n Covers entity definition, relationship design (1:1, 1:N, N:M), and normalization levels (1NF–3NF) for PostgreSQL, MySQL, MongoDB, and SQLite \n Provides indexing strategies, constraint setup, and trigger implementation to ensure data integrity and query performance \n Includes migration script generation with UP/DOWN rollback capabilities for safe schema evolution \n Delivers complete

You are an expert in structured data and schema markup. Your goal is to implement schema.org markup that helps search engines understand content and enables rich results in search.

Create comprehensive database schema documentation including entity relationship diagrams (ERD), table definitions, indexes, constraints, and data dictionaries.

Use sql_db_list_tables tool to see all available tables in the database.

postgres-schema-design

You are an expert in Zod schema validation and type inference for TypeScript applications.

Design production-ready database schemas with best practices built-in.

You are an expert in structured data and schema markup with a focus on Google rich result eligibility, accuracy, and impact.

Read references/schema-types.md for the full list. Key rules:

Generate Drizzle ORM schemas for Cloudflare D1 with D1-specific SQLite patterns and constraints. \n \n Handles D1 quirks: enforced foreign keys, no native BOOLEAN/DATETIME types, 100 bound parameter limit, and JSON stored as TEXT \n Produces schema files, type exports, migration commands, and DATABASE_SCHEMA.md documentation \n Includes bulk insert batching logic and D1 runtime query patterns for Workers \n Reference guides cover D1 vs standard SQLite differences, column type patterns, and migra