Tag: schema
Drizzle ORM Schema and Query Best Practices
This guide details best practices for defining PostgreSQL schemas, including naming conventions, foreign key management, and index creation using Drizzle ORM. It strongly recommends using the explicit db.select() builder API for complex que…
Drizzle database migration best practices guide
This skill guides developers through generating and managing database schema migrations using Drizzle Kit. It emphasizes best practices for writing idempotent SQL, ensuring safe and repeatable schema evolution across various database operat…
API Breaking Change Detection and Prevention
This skill enforces a critical guideline, automatically detecting potential breaking changes across API endpoints, schemas, and contracts. It halts execution and requires explicit user validation before implementing any modification that co…
Managing idempotent database schema migrations
This skill guides developers through generating, customizing, and optimizing database migrations using Drizzle Kit. It emphasizes best practices for writing idempotent SQL, ensuring schema changes are safe to re-run.
Structured Database Querying via Schema Exploration
This skill enforces an explore-then-query workflow, guiding the agent to first inspect database schemas and object structures using dedicated MCP tools before executing SQL statements. It ensures robust data retrieval by preventing guesswor…
Comprehensive database introspection and schema querying
This skill provides comprehensive introspection into a live database binding, allowing developers to query schema details, foreign keys, row-level security policies, and stored procedures. It offers granular tools for verifying connectivity…
Deep database introspection and schema querying tool
This tool suite provides deep introspection into a live database binding, allowing developers to query schema details, foreign key relationships, row-level security policies, and stored procedure definitions. It is essential for verifying c…
Database introspection and schema querying tool
This suite of tools provides deep introspection into a connected database, allowing developers to query schema details, foreign keys, row-level security policies, and stored procedures. It offers granular access to metadata, including table…
Comprehensive context for code entities
This skill provides bounded, entity-centered context bundles for core application components. It allows developers to gather comprehensive information—such as schema, dependencies, and policies—for a specific table, route, or RPC in a singl…
Database introspection and schema querying skill
This skill provides comprehensive introspection into a connected database, allowing the agent to query table schemas, foreign key relationships, row-level security policies, and stored procedure definitions. It is ideal for understanding th…