Architecting Data

What it does

This skill enables AI agents to design data architectures, including defining schemas for relational databases and NoSQL stores. It can generate SQL scripts for creating tables and indexes, as well as suggest appropriate data types and constraints. The agent can also propose optimal indexing strategies to improve query performance.

When to use it

• You need a database schema designed for a new application or feature.
• You're migrating data between different database systems (e.g., relational to NoSQL).
• Existing queries are slow, and you suspect the database indexes are not optimal.
• You want to define a data model that supports specific analytical requirements.

Key capabilities

• Schema design for relational databases
• Schema design for NoSQL stores
• Generation of SQL scripts (CREATE TABLE, CREATE INDEX)
• Data type and constraint recommendations
• Indexing strategy suggestions

Example prompts

• "Design a database schema to store customer order information, including products, quantities, and shipping addresses."
• "I'm moving from PostgreSQL to MongoDB. Can you design a NoSQL schema that mirrors my existing relational data?"
• "My query for retrieving recent orders is slow. Suggest some indexes I could add to improve performance."

Tips & gotchas

The agent’s output should be reviewed by a database administrator or experienced developer, as it may require adjustments based on specific environment and operational considerations. Providing context about existing systems or data volumes will help the agent generate more relevant suggestions.