Firestore ๋ฐ์ดํฐ ๋ชจ๋ธ๋ง๊ณผ ์คํค๋ง ์ค๊ณ ํจํด์ ์ ์ฉํฉ๋๋ค. ์ ์ปฌ๋ ์ ์ถ๊ฐ, ๊ด๊ณ ์ค๊ณ, ์ธ๋ฑ์ค ์ต์ ํ, ๋ฐ์ดํฐ ๋ง์ด๊ทธ๋ ์ด์ ์ ์ฌ์ฉํ์ธ์. NoSQL ํน์ฑ์ ๋ง๋ ๋น์ ๊ทํ ์ ๋ต์ ํฌํจํฉ๋๋ค.
ใใผใฟใใผในในใญใผใ่จญ่จใจๆ้ฉๅใๆฏๆดใใพใใๆญฃ่ฆๅๆฆ็ฅใใคใณใใใฏใน่จญ่จใใใใฉใผใใณในๆ้ฉๅใๆไพใใพใใใใผใฟใขใใซ่จญ่จใใใผใฟใใผในๆง้ ใฎๆ้ฉๅใๅฟ ่ฆใชๅ ดๅใซไฝฟ็จใใฆใใ ใใใ
Manages PostgreSQL database operations including Alembic migrations (creation, application, rollback), database backups and restoration for both development and production environments, shell access, and pgvector extension management. This skill should be used when creating schema changes, running migrations, backing up data, or troubleshooting database issues.
Generates a Query class for read-only operations. Use when implementing complex data retrieval, reports, or optimized fetching (e.g., "Create a query to list students with GPA").
Async SQLAlchemy 2.0+ database patterns for FastAPI including session management, connection pooling, Alembic migrations, relationship loading strategies, and query optimization. Use when implementing database models, configuring async sessions, setting up migrations, optimizing queries, managing relationships, or when user mentions SQLAlchemy, async database, ORM, Alembic, database performance, or connection pooling.
Add a relation between two existing entities. Use when linking entities with ManyToOne, OneToMany, or ManyToMany relationships.
ๆฅ่ฏข็งๆทๅ็ป็ปไฟกๆฏ๏ผv3_userๆฐๆฎๅบ๏ผใไฝฟ็จ exec_sql ๅทฅๅ ทๆง่กๆฅ่ฏขใ
Expert PostgreSQL database administrator specializing in query optimization, indexing strategies, and advanced SQL patterns. Masters replication, partitioning, and performance tuning for mission-critical database systems.
Advanced SQLModel patterns and comprehensive database migrations with Alembic. Use when creating SQLModel models, defining relationships (one-to-many, many-to-many, self-referential), setting up database migrations, optimizing queries, solving N+1 problems, implementing inheritance patterns, working with composite keys, creating indexes, performing data migrations, or troubleshooting Alembic issues. Triggers include "SQLModel", "Alembic migration", "database model", "relationship", "foreign key", "migration", "N+1 query", "query optimization", "database schema", or questions about ORM patterns.
ๆฅ่ฏข้ๆ่ฟๆฅๅจๅAPI้ ็ฝฎ๏ผv3_openapiๆฐๆฎๅบ๏ผใไฝฟ็จ exec_sql ๅทฅๅ ทๆง่กๆฅ่ฏขใ
ใใผใฟใใผในใใคใฐใฌใผใทใงใณใไฝๆใใ้ใซไฝฟ็จใ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.
