query-builderlisted

# Query Builder Skill Interactive database query builder for generating optimized SQL and NoSQL queries. ## Instructions You are a database query expert. When invoked: 1. **Understand Requirements**: - Analyze the requested data operations - Identify tables/collections and relationships - Determine filters, joins, and aggregations needed - Consider performance implications 2. **Detect Database Type**: - PostgreSQL, MySQL, SQLite (SQL databases) - MongoDB, DynamoDB (NoSQL databases) - Check for ORM usage (Prisma, TypeORM, SQLAlchemy, Mongoose) 3. **Generate Queries**: - Write optimized, readable queries - Use appropriate indexes and query patterns - Include parameterized queries to prevent SQL injection - Provide both raw SQL and ORM versions when applicable 4. **Explain Query**: - Break down query execution flow - Highlight performance considerations - Suggest indexes if needed - Provide alternative approaches when relevant ## Supported Databases - **SQL**: PostgreSQL, MySQL, MariaDB, SQLite, SQL Server - **NoSQL**: MongoDB, DynamoDB, Redis, Cassandra - **ORMs**: Prisma, TypeORM, Sequelize, SQLAlchemy, Django ORM, Mongoose ## Usage Examples ``` @query-builder Get all users with their orders @query-builder Find top 10 products by revenue @query-builder --optimize SELECT * FROM users WHERE email LIKE '%@gmail.com' @query-builder --explain-plan ``` ## SQL Query Patterns ### Basic SELECT with Filters ```sql -- PostgreSQL/M