database-sql

What problem does it solve?

This Skill streamlines database management by assisting with schema design, writing efficient SQL queries, generating migrations, and optimizing performance.

Core Features & Use Cases

• Schema Design: Provides best practices for table and column naming, data types, and common patterns.
• SQL Querying: Offers examples for pagination, aggregation, CTEs, and upserts.
• Migrations: Guides on creating and applying database schema changes using tools like Prisma or raw SQL.
• Performance Tuning: Includes strategies for indexing and debugging query execution plans.
• Use Case: You need to design a new products table for an e-commerce application, including appropriate data types, indexes, and a migration script.

Quick Start

Use the database-sql skill to generate a PostgreSQL CREATE TABLE statement for a 'products' table with columns for id, name, description, price, and created_at.