database-schema

Verify database schema definitions before implementing queries and models.

Updated Jun 19, 2026
One-click install
npx skills add https://github.com/lciacci/tessera --skill database-schema-lciacci
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-schema
Source: https://github.com/lciacci/tessera/tree/main/skills/database-schema
Command: npx skills add https://github.com/lciacci/tessera --skill database-schema-lciacci

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill prevents database coding errors caused by guessed or outdated table names, columns, types, relationships, nullable fields, and enum values by requiring schema verification before implementation.

Core Features & Use Cases

  • Schema Verification: Read the relevant schema and confirm tables, columns, types, relationships, and nullability before writing database code.
  • Type-Safe Development: Use generated ORM or database types with Drizzle, Prisma, Supabase, SQLAlchemy, and related stacks to catch schema mismatches early.
  • Migration Guidance: Coordinate schema updates, migration generation, type regeneration, reference documentation, type checking, and test validation.
  • Use Case: When adding an order history endpoint, verify the orders schema, confirm foreign keys and nullable fields, use generated types in queries, and validate the implementation with type checks and tests.

Quick Start

Use the database-schema skill to inspect the project's schema and produce a verification checklist before implementing the requested database change.

Frequently Asked Questions about database-schema

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I verify database schema definitions before writing queries?

To verify database schema definitions, inspect the authoritative schema to confirm tables, columns, types, relationships, and nullability before writing database queries or models. This prevents coding errors caused by guessed or outdated schema structures.

How do I prevent type mismatch errors when working with Prisma or Drizzle migrations?

Prevent type mismatch errors during migrations by regenerating ORM types after schema changes, then completing type-checking and test validation to ensure generated types match the updated database schema.

Does database schema validation work with Supabase and SQLAlchemy?

Yes, database schema validation works with Supabase, SQLAlchemy, Drizzle, Prisma, TypeORM, and raw SQL projects by validating schema definitions, foreign keys, and nullable fields to catch mismatches early.

What is the best way to coordinate database schema updates and type generation?

The best way to coordinate schema updates is to apply schema changes, generate migrations, regenerate ORM types, update reference documentation, and validate the implementation with type checks and tests to ensure full schema consistency.

Why do my database queries fail after adding nullable fields or foreign keys?

Database queries fail after adding nullable fields or foreign keys when schema definitions are not verified before implementation. Validate the authoritative schema, confirm constraints, and regenerate types to prevent mismatches.