Database Design

The database-design skill enables AI agents to architect robust data structures, generate SQL schemas, and optimize query performance for specific application requirements. It translates business logic into efficient relational or non-relational database models tailored to your project's scale and complexity.

When to use it

• Initial Architecture: Defining table structures, primary keys, and foreign key relationships during the early planning phase of a new data-driven application.
• Schema Migration: Generating migration scripts to evolve existing databases while maintaining data integrity and minimizing downtime.
• Query Optimization: Analyzing slow-performing database queries and rewriting them for better speed and resource utilization.
• NoSQL Conversion: Designing document or graph-based schemas when transitioning from traditional relational models to handle unstructured data.

Key capabilities

• Generates normalized SQL schemas based on entity-relationship diagrams (ERDs) or textual descriptions.
• Creates indexes and constraints to enforce data integrity and improve retrieval speeds.
• Designs flexible NoSQL structures for document stores like MongoDB or graph databases like Neo4j.
• Produces migration scripts compatible with tools like Flyway or Liquibase.

Example prompts

• "Design a normalized SQL schema for an e-commerce platform including users, products, orders, and inventory tables."
• "Optimize this slow-performing SQL query that retrieves customer order history by adding appropriate indexes."
• "Create a document-based NoSQL schema in JSON format to store social media posts with nested comments and likes."

Tips & gotchas

Ensure you provide clear context about data volume and access patterns, as these heavily influence whether normalization or denormalization is best. Always validate generated schemas against your specific database engine's syntax limitations before deployment.