🗄️SQL and Databases Skills
Browse skills in the SQL and Databases category.
Supabase Postgres Best Practices
A powerful skill for Claude agents.
ddl-generator
Generate PostgreSQL DDL, sample data, and query examples from immutable data model JSON. Use when the user asks to generate database schema, create sample data, or prepare SQL examples from a model.json in artifacts/{project-name}/ directory. Triggers include "DDLを生成", "サンプルデータを作って", "スキーマとデータを用意", or similar requests to transform a data model into executable SQL.
query-validation
SQL query review and validation for correctness, performance, and best practices. Use when reviewing queries for logical errors, optimizing query performance, checking for SQL anti-patterns, or validating business logic implementation in SQL.
schema-mapper
Database schema understanding and relationship mapping. Use when exploring unfamiliar databases, documenting table relationships, identifying join paths, or generating ERD documentation for existing schemas.
persistent-sector-caching
Cache yfinance sector data permanently to avoid Yahoo Finance rate limits. Trigger when: (1) 401 errors during sector fetching, (2) sector updates take too long, (3) need selective sector refresh.
backend-migrations
Create and manage database migrations with reversible up/down methods, zero-downtime deployment strategies, and proper schema versioning. Use this skill when creating database migration files, altering table schemas, adding or modifying database indexes, or implementing data migrations. Use when working with migration tools like TypeORM migrations, Sequelize migrations, Alembic (Python), Rails migrations, Flyway, or Liquibase. Use when writing migration files (e.g., YYYYMMDDHHMMSS_migration_name.ts, 001_create_table.sql, versions/*.py) or when modifying database schema in a version-controlled manner. Use when handling backwards compatibility for high-availability deployments or when separating schema changes from data migrations.
database-schema
Generate comprehensive database schemas with proper relations, migrations, and ORM/ODM models for PostgreSQL, MongoDB, and SQLite. Use when creating database schemas that integrate with FastAPI applications, including SQLAlchemy models for SQL databases, PyMongo/ODMantic models for MongoDB, Alembic migrations, and proper relationship definitions.
backend-models
Define and structure database models and entities with proper naming conventions, timestamps, data integrity constraints, relationships, and validation layers. Use this skill when creating or modifying ORM model definitions, database entity classes, schema definitions, or data access layer objects. Use when working with TypeORM entities, Sequelize models, SQLAlchemy models, Mongoose schemas, Django models, Prisma schema files, or any framework-specific model files (models.ts, entities.py, schema.prisma, models.py). Use when defining table structures, foreign key relationships, database constraints (NOT NULL, UNIQUE), indexes, or multi-layer validation rules. Use when implementing repository patterns or designing data models that balance normalization with query performance.
database-design
数据库设计指南。当用户需要设计数据库 Schema、优化索引、规划表结构、处理数据关系或进行数据库性能优化时使用此技能。
ef-migrations
Instructions for managing Entity Framework Core migrations using project scripts. Use when adding, removing, applying, or listing database migrations.
data-catalog-entry
Standardized metadata creation for data assets. Use when cataloging new datasets, documenting data sources, defining data ownership, or creating searchable data documentation.
spec-writing-database
Writes database schema specifications using Mermaid ER diagrams and defines table structures for multi-tenant entities. Use when designing database schemas, creating entity-relationship diagrams, or specifying database constraints for GloboTicket features.
unified-sql
Query databases and explore data. Use when the user mentions database, query, SQL, table, schema, data exploration, "check the data", "look at the database", "what's in the table", "show me records", "find in database", PostgreSQL, MySQL, SQLite, cross-database joins, data validation, or export query results. Also triggers on: exploring schemas, sampling data, running analytics queries, checking data quality, or any task involving database operations.
rails-migrations
This skill should be used when the user asks about "migrations", "database schema", "create_table", "add_column", "remove_column", "add_index", "foreign keys", "db:migrate", "db:rollback", "schema.rb", "change_column", "reversible", "references", "timestamps", or needs guidance on modifying database structure in Rails applications.
managing-migrations
Manages Entity Framework Core migrations using project scripts. Use when creating, applying, listing, or removing database migrations.
backend-queries
Write optimized and secure database queries using parameterized queries, eager loading, strategic indexing, and proper transaction management. Use this skill when writing database queries, repository methods, or data fetching logic that interacts with SQL or NoSQL databases. Use when implementing query builders, ORM query methods, raw SQL queries, or database service functions. Use when working with files containing database access code (repositories.ts, services.ts, queries.py, dao.java), when optimizing N+1 query problems, implementing query caching strategies, or writing queries with JOINs and WHERE clauses. Use when preventing SQL injection vulnerabilities, setting up query timeouts, or wrapping related operations in database transactions.
supabase-audit
Supabase RLS/perf audit. Triggers on "SUPABASE:" prefix.
etl-duckdb
Load CSV/XLSX into DuckDB with validation and an ETL markdown report
drizzle-game-schema
Drizzle ORM database schema patterns for games including player profiles, inventories, leaderboards, game sessions, and achievements. Use when designing database schemas, creating migrations, optimizing queries, or implementing save systems. Triggers on requests for game database design, Drizzle schemas, player data storage, or leaderboard systems.
conventions
SQL schema conventions for PSRDatabase. When writing SQL schemas for PSRDatabase, follow these conventions strictly.
sql-to-business-logic
Translate SQL queries into plain business language. Use when explaining complex queries to non-technical stakeholders, documenting query logic, or creating business glossaries from technical implementations.
sqlmodel
SQLModel - Pydantic + SQLAlchemy combined. This skill should be used when building FastAPI apps with database, creating ORM models, data validation with database persistence, or any Python project needing both validation and ORM. Triggers on "create database model", "add SQLModel", "database with FastAPI", "ORM model", or any SQLModel-related development.
sqlmodel
Comprehensive SQLModel development assistance including model creation, relationship handling, database operations, and integration with FastAPI. Use when Claude needs to work with SQLModel projects for: (1) Creating data models with SQLModel, (2) Setting up database connections and sessions, (3) Implementing relationships between models, (4) Performing CRUD operations, (5) Handling advanced features like UUIDs and Decimals, or any other SQLModel database operations.
activerecord
This skill should be used when the user asks about "ActiveRecord", "database queries", "associations", "validations", "migrations", "scopes", "callbacks", "N+1 queries", "eager loading", "includes", "joins", "eager_load", "preload", "database optimization", "model relationships", "has_many", "belongs_to", "has_one", "polymorphic associations", "pluck", "exists", or needs guidance on database-related Rails topics.
data-modeler
イミュータブルデータモデルに基づくデータモデリング自動化Skill。ブラックボードパターンで段階的にエンティティ抽出からER図生成まで実行します。
database-optimizer
Analyze and improve database performance through safe, measurable query, index, and configuration optimizations.
semantic-model-builder
Create comprehensive semantic layer documentation for analytics assets. Use when documenting data models, defining business metrics, creating data dictionaries, or building context for AI-assisted analysis.
migrate
生成数据库迁移文件。当用户需要创建表、修改表结构、添加索引等数据库变更时使用此 skill。
database-migrator
Generates database migrations for both SQLite and PostgreSQL. Use when user needs to add columns, create tables, add indexes, or modify schema. Triggers on "create migration", "add column", "new table", "database change".
ef-core-patterns
Entity Framework Core best practices for configuration, queries, concurrency, and multi-tenancy.
grdb
Use when writing raw SQL with GRDB, complex joins across 4+ tables, window functions, ValueObservation for reactive queries, or dropping down from SQLiteData for performance. Direct SQLite access for iOS/macOS with type-safe queries and migrations.
regenerate-embeddings
Manages OpenAI embeddings for title vector search, including batch regeneration, single title updates, verification, and cost estimation. This skill should be used when regenerating embeddings for new titles, fixing missing embeddings, or updating embeddings after content changes.
migration-master
Specialized in database migrations and data seeding. Trigger this when creating tables, modifying schemas, or preparing initial data.
sql-pro
Write complex SQL queries, optimize execution plans, and design normalized schemas. Masters CTEs, window functions, and stored procedures. Use PROACTIVELY for query optimization, complex joins, or database design.
do-domain-database
PostgreSQL, MongoDB, Redis 및 현대적 애플리케이션을 위한 고급 데이터 패턴을 다루는 Database 전문가
database-optimizer
Optimize SQL queries, design efficient indexes, and handle database migrations. Solves N+1 problems, slow queries, and implements caching. Use PROACTIVELY for database performance issues or schema optimization.
neon-cli
Neon CLI expert for serverless PostgreSQL. Use when users need to manage Neon projects, branches, databases, roles, or connection strings.
construction-data-migration
Specialized skill for migrating Excel-based construction project management data to web platform. Use when the user needs to transform, validate, or migrate data from Excel systems including Plan Start Sheets (40 plans, 567 options), PDSS workflows, job coordination data, contract tracking, time entries (3,355+ records), or subdivision data (31 subdivisions). Also use for data structure design, ETL pipeline creation, and data validation for construction workflows.
d1-drizzle-migrations
Use this when changing the database schema, generating/applying Drizzle migrations for Cloudflare D1 (SQLite), or working with Better Auth schema generation.
athena-queries
Run AWS Athena queries against telemetry data. Use when executing SQL against telemetry-parser-db (raw Parquet from telemetry-parser-service) or telemetry_alerts (DBT-transformed tables). Also for Glue catalog exploration, partition debugging, or filtering by $path pseudo-column.
database-patterns
PostgreSQL + Redis database design patterns. Use for data modeling, indexing, caching strategies. Covers JSONB, tiered storage, cache consistency.
postgresql
PostgreSQL 14+ database design, Flyway migrations, and JPA queries for the casino platform.Use when: Creating or modifying database tables, writing migrations, designing entities,writing repository queries, or troubleshooting data layer issues.
prisma-patterns
Prisma schema conventions, migrations, and query patterns for TaxHelper. Use when modifying the database schema, writing complex queries, or optimizing database access.
sqlmodel-database
Expert in SQLModel ORM patterns for async PostgreSQL operations. Covers model definitions, relationships, async session management, queries with filtering/joins, and Neon PostgreSQL integration. Use for all database schema and query implementations.
laravel-migrations
Create database migrations with schema builder, indexes, foreign keys, and seeders. Use when designing database schema, creating tables, or modifying columns.
db-migrate
Create database migration scripts following project patterns. Use when user mentions "migration", "add column", "alter table", "schema change", or "database update".
supabase-schema-validator
Validates Supabase database schema changes for the NABIP AMS, ensuring migrations align with member management, event tracking, chapter hierarchy, and financial models. Use when working with Supabase tables, RLS policies, or database migrations for members, chapters, events, courses, or transactions.
do-platform-supabase
PostgreSQL 16, pgvector, RLS, 실시간 구독, Edge Functions를 다루는 Supabase 전문가. Supabase 백엔드를 활용한 풀스택 앱 개발 시 사용
do-platform-convex
Convex 실시간 백엔드 전문가 - TypeScript 우선 reactive 패턴, optimistic updates, server functions. 실시간 협업 앱 구축 시 사용.
masterdata-explorer
GLOWマスタデータのスキーマ調査とSQL分析。jqでテーブル構造確認、DuckDBでCSVクエリ。マスタデータ、CSV、スキーマで使用。