Design database schemas, write SQL queries, and create migrations.
npx skills add https://github.com/asgarovf/locusai --skill database-sql
Please help me install this Agent Skill. Skill: database-sql Source: https://github.com/asgarovf/locusai/tree/main/skills/database-sql Command: npx skills add https://github.com/asgarovf/locusai --skill database-sql
This Skill streamlines database management by assisting with schema design, writing efficient SQL queries, generating migrations, and optimizing performance.
products table for an e-commerce application, including appropriate data types, indexes, and a migration script.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.
High-intent search queries and answers about installing and using this skill.
Database schema design involves selecting appropriate data types for columns, following table and column naming best practices, and implementing indexing strategies to optimize query performance across PostgreSQL and MySQL.
Writing efficient SQL queries utilizes Common Table Expressions (CTEs), upserts, pagination, and aggregation techniques. Performance debugging is achieved by analyzing query execution plans using EXPLAIN ANALYZE to identify bottlenecks.
SQL migrations support integration with ORM tools including Prisma, Drizzle, TypeORM, and SQLAlchemy. This allows you to create and apply database schema changes using either raw SQL or your preferred ORM framework.
Optimizing slow PostgreSQL query performance requires applying targeted indexing strategies and debugging execution plans with EXPLAIN ANALYZE. This identifies bottlenecks in your SQL queries to streamline database operations.
Generating a migration script for a products table involves creating a CREATE TABLE statement with columns like id, name, description, price, and created_at, then applying the schema changes using raw SQL or an ORM tool.
zero3041Guide database migrations across PostgreSQL, MySQL, and ORMs.
mohitmishra786Design normalized database schemas, write SQL queries, and manage migration files.
siondwRun SQL queries against Supabase tables to inspect contest and user data.
Geralt1983Design relational and NoSQL database schemas with normalization and indexing guidance.