SQL 資料庫

This skill should be used for database schema design, indexes, query optimization, migrations, SQL, PostgreSQL, MySQL, ORM patterns, data modeling, database relationships

Manage Todo operations (Create, Read, Update, Delete) using SQLModel and Postgres. Use when the user wants to organize tasks.

Implement data persistence using SQLite with Dapper, JSON files, or event sourcing.Use when: "database", "save data", "store", "CRUD", "create table", "query", "SQL","SQLite", "Dapper", "file storage", "JSON file", "event sourcing", "persistence","read from database", "write to database", "data access", "repository".Creates code in src/Server/Persistence.fs with async I/O patterns.

Prisma/SQL 마이그레이션 관리. Use when:(1) 스키마 변경, (2) 마이그레이션 생성/적용, (3) DB 동기화,(4) 마이그레이션 상태 확인, (5) 롤백 필요 시.

Generate SQL schema for Agentuity Auth tables. Use for managing authentication credentials

1800+ lines of database architecture mastery - SQLite, Hive, ObjectBox, Firestore, encryption, offline-first, sync with production-ready code examples.

Firebase Firestore specialist covering NoSQL patterns, real-time sync, offline caching, and Security Rules. Use when building mobile-first apps with offline support, implementing real-time listeners, or configuring Firestore security.

Execute read-only SQL queries against multiple PostgreSQL databases. Use when: (1) querying PostgreSQL databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.

Extend the Supabase PostgreSQL database schema following this project's declarative schema patterns, migration workflow, and type generation pipeline. Use when adding tables, columns, enums, RLS policies, triggers, or database functions.

Supabase PostgreSQL schema management, 86+ migrations, RLS policies, and type generation.Handles table creation, schema changes, migrations, foreign key constraints, and migration workflows.Use when working with database schema, migrations, data modeling, or type definitions,or when user mentions database changes, table modifications, schema updates, migration failures,"relation does not exist" errors, foreign key issues, Supabase schema operations, users table, accounts table, or holdings table.

Component skill for systematic SQL query development in DataPeeker analysis sessions

This skill should be used when the user asks to "debug backend tests", "fix pytest failures", "analyze Python errors", "fix FastAPI bugs", or mentions keywords like "pytest", "IntegrityError", "ValidationError", "SQLAlchemy", "FastAPI". It provides the complete bugfix workflow knowledge including error classification, confidence scoring, and TDD best practices for Python/FastAPI backends.

Deploys PostgreSQL on Kubernetes using the CloudNativePG operator with automated failover.Use when setting up PostgreSQL for production workloads, high availability, or local K8s development.Covers operator installation, cluster creation, connection secrets, and backup configuration.NOT when using managed Postgres (Neon, RDS, Cloud SQL) or simple Docker containers.

Comprehensive performance analysis and optimization for Justice Companion: React rendering, SQLite query performance, bundle size analysis, memory leak detection. Use when debugging slow UI, optimizing database queries, or reducing app footprint.

I/O platform functions for the East language on Node.js. Use when writing East programs that need SQL databases (SQLite, PostgreSQL, MySQL), NoSQL databases (Redis, MongoDB), S3 storage, file transfers (FTP, SFTP), file format parsing (XLSX, XML), or compression (Gzip, Zip, Tar). Triggers for: (1) Writing East programs with @elaraai/east-node-io, (2) Database operations with SQL.SQLite, SQL.Postgres, SQL.MySQL, NoSQL.Redis, NoSQL.MongoDB, (3) Cloud storage with Storage.S3, (4) File transfers with Transfer.FTP, Transfer.SFTP, (5) Format parsing with Format.XLSX, Format.XML, (6) Compression with Compression.Gzip, Compression.Zip, Compression.Tar.

Expert guidance for Drizzle ORM including schema definition, queries, relations, migrations, TypeScript integration with SQLite/PostgreSQL, and Drizzle Studio. Use this when working with type-safe database operations, schema management, or ORM queries.

Flyway database migrations - use for schema changes, data migrations, version management, and PostgreSQL DDL

PostgreSQL database optimization combining institutional knowledge with live analysis

Create, configure, or update Databricks' Lakeflow Spark Declarative Pipelines (SDP), also known as LDP, or historically Delta Live Tables (DLT). User should guide on using SQL or Python syntax.

Go database operations - SQL, ORMs, transactions, migrations