ใใผใฟใใผในใใคใฐใฌใผใทใงใณใไฝๆใใ้ใซไฝฟ็จใAtlas CLIไฝฟ็จใmaster/shardingใฎใใคใฐใฌใผใทใงใณใSQLiteๆงๆใDBๅคๆดใใใผใใซ่ฟฝๅ ใใซใฉใ ่ฟฝๅ ใใใคใฐใฌใผใทใงใณใใกใคใซไฝๆๆใซไฝฟ็จใ
PostgreSQL 16 database documentation. Use for SQL queries, indexes, transactions, JSON operations, full-text search, and performance tuning.
This skill should be used when the user asks about "ActiveRecord", "database queries", "query optimization", "N+1 queries", "eager loading", "associations", "migrations", "database indexes", "SQL performance", "ActiveRecord callbacks", "scopes", or needs guidance on efficient database access patterns in Rails 7+.
Drizzle ORM patterns for Neon PostgreSQL. Use when creating tables, schemas, migrations, or database queries.
Query the worklog database for context, knowledge, errors, and history
Ecto schemas, changesets, queries, migrations, and database patterns for Elixir applications
Audit SQLite persistence layer for unused tables and broken integrations. Trigger when: (1) checking database usage, (2) cleaning up schema, (3) finding missing methods.
SQLite problem-solving patterns for embedded/edge deployments. Use when: connection setup, "database locked" errors, ALTER TABLE workarounds, concurrency problems, FTS setup, SQLite-specific gotchas. Do not use for: basic DDL/DML syntax (use context7 MCP), schema design decisions (use data-modeling skill first). Workflow: data-modeling skill (design) โ this skill (implement). Decision: If asking "should I use PostgreSQL instead?" โ see comparison section at bottom.
Long FK ์ ๋ต, QueryDSL DTO Projection, N+1 ํด๊ฒฐ. JPA ๊ด๊ณ ์ด๋ ธํ ์ด์ ๊ธ์ง. /kb-persistence ๋ช ๋ น ์ ์๋ ํ์ฑํ.
SQL ์ฟผ๋ฆฌ ์ต์ ํ, ์ธ๋ฑ์ค ์ ๋ต ๋ฐ EXPLAIN ๋ถ์์ ๋ง์คํฐํ์ฌ ๋ฐ์ดํฐ๋ฒ ์ด์ค ์ฑ๋ฅ์ ํ๊ธฐ์ ์ผ๋ก ํฅ์์ํค๊ณ ๋๋ฆฐ ์ฟผ๋ฆฌ๋ฅผ ์ ๊ฑฐํฉ๋๋ค. ๋๋ฆฐ ์ฟผ๋ฆฌ ๋๋ฒ๊น , ๋ฐ์ดํฐ๋ฒ ์ด์ค ์คํค๋ง ์ค๊ณ ๋๋ ์ ํ๋ฆฌ์ผ์ด์ ์ฑ๋ฅ ์ต์ ํ ์ ์ฌ์ฉํ์ธ์.
Type-safe SQL with Drizzle ORM in TypeScript. Use when defining database schemas, writing queries, setting up relations, running migrations, or working with PostgreSQL/MySQL/SQLite data layers.
Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced features. Use when designing database schemas, creating tables, or reviewing database structure.
Armazena e consulta memรณria persistente de projetos em banco PostgreSQL. Use quando: (1) tomar decisรตes tรฉcnicas importantes, (2) identificar TODOs/melhorias, (3) documentar contexto do projeto, (4) consultar decisรตes anteriores. O Claude deve AUTOMATICAMENTE salvar decisรตes importantes e consultar memรณria relevante. Identificaรงรฃo do projeto รฉ automรกtica via git repo + branch.
Automate loading PostgreSQL backups from SQL files into local databases running in Docker containers for debugging and testing. Use when working with PostgreSQL database backups, restoring QA/production data to local environments, setting up local debugging environments with real data, or when users mention loading/restoring database backups to Docker containers.
Migrate from Prisma 5 to Prisma 6 handling breaking changes including Buffer to Uint8Array, implicit m-n PK changes, NotFoundError to P2025, and reserved keywords. Use when upgrading Prisma, encountering Prisma 6 type errors, or migrating legacy code.
PostgreSQL database operations specialist using Drizzle ORM for schema management, queries, and migrations
PostgreSQL query optimization and performance tuning reference. Use when analyzing slow queries, interpreting EXPLAIN output, optimizing indexes, or troubleshooting database performance issues.
This skill should be used when designing database schemas, choosing between SQL and NoSQL databases, modeling relationships, or optimizing database queries. It provides guidance on relational data modeling, SQL vs NoSQL decision-making, and database best practices.
Use when designing database schemas from business requirements, translating vague requirements into concrete SQL definitions, or validating database designs with non-technical stakeholders. Provides a systematic methodology that decouples logical business modeling from physical implementation to reduce cognitive load and ensure business-driven design.
Descobre campos e estrutura de qualquer modelo do Odoo. Lista campos de tabela, busca campo por nome, inspeciona registro, faz consulta generica. Use quando: nao conhecer um modelo Odoo, precisar descobrir nome de campo, explorar estrutura de tabela, consulta em modelo nao mapeado.
SQL best practices with pgTAP, sqlfluff 3.2, query optimization, and
