SQL 資料庫

Prevents RCE, SQL injection, and common vulnerabilities through validation and safe coding practices. Use when implementing or reviewing security-sensitive code involving user input, database queries, or command execution.

Generate learning materials from mature patterns. Use when user says "teach me", "explain this pattern", "create a guide", "how does X work", "document this for others". Auto-trigger when sharing knowledge with team.

Reference for PDA Engine taxonomy mapping domain. Use when working with vendor product imports, CSV imports, taxonomy structures, category/attribute mappings, state hash change detection, or understanding the vendor→internal→marketplace mapping flow. Covers data models, workflows, API endpoints, and PostgreSQL bulk insert patterns.

Execute safe SELECT queries against MySQL/MariaDB databases with connection pooling, SQL injection prevention, and automatic result formatting. Activated when users mention "mysql", "mariadb", or need SQL database operations.

Comprehensive guide for implementing Supabase Realtime features with best practices, scalable patterns, and migration strategies. Use when building realtime features in Supabase applications including messaging, notifications, presence, live updates, collaborative features, or migrating from postgres_changes to broadcast. Covers client setup, database triggers with realtime.broadcast_changes, RLS authorization, naming conventions, and performance optimization.

Follow the project's Python-based tech stack using uv, FastMCP, Claude Agent SDK, Pydantic v2, SQLite with SQLModel, and pytest with ruff. Use this skill when writing Python code for the MCP Task Aggregator. When using FastMCP to create MCP servers or tools. When working with Claude Agent SDK for AI agents. When defining Pydantic models or using pydantic-settings for configuration. When writing SQLModel queries or database operations. When using loguru for logging. When integrating with Jira (jira-python), GitHub (pygithub), or Linear (linear-sdk). When running pytest tests or ruff linting. When configuring GitHub Actions CI/CD.

SQL to OSC (Online Schema Change) conversion expert for Flyway migration scripts.Use when: (1) Converting SQL migration files to OSC format, (2) User mentions "OSC", "轉換 OSC", "osc.txt", or "Online Schema Change", (3) Working with Flyway ALTER TABLE/CREATE INDEX statements that need OSC conversion.

Diagnóstico y solución de problemas de MCP servers en Claude Desktop. Usar cuando los servidores MCP muestran "Server disconnected", fallan al conectar, o tienen problemas de handshake. Cubre servidores Python (MySQL, SQL Server, PostgreSQL) y Node.js en Windows/macOS/Linux.

SQL Server administration and maintenance. Use for database backups, security, user management, maintenance tasks, monitoring, and troubleshooting.

Learn from database query patterns and recommend optimized approaches

REQUIRED before implementing any game feature, scoring logic, state transition, or decision-making. ALL business logic lives in PostgreSQL - frontend is presentation only. Load this to understand where code belongs: database function vs component. Covers RPC patterns, SECURITY DEFINER, and anti-patterns.

Solo RPG mechanical tools for dice rolling, tarot draws, oracles, name generation, character/location/memory management, and story retrieval. Use when the user asks to roll dice, draw tarot cards, consult oracles, generate names, load characters or locations, track memories, or pull from story collections during RPG sessions.

Database operations for SQLite, PostgreSQL, and MySQL. Use for queries, schema inspection, migrations, and AI-assisted query generation.

Save backtest results to SQLite database for comparison. Trigger when: (1) tracking backtest history, (2) comparing model performance, (3) querying best backtests.

Design PostgreSQL schemas with migrations, seeding, and documentation. Use when creating tables, writing migrations, or setting up database structure.

WHEN: SQL query review, query optimization, index usage, N+1 detection, performance analysisWHAT: Query plan analysis + Index recommendations + N+1 detection + Join optimization + Performance tuningWHEN NOT: Schema design → schema-reviewer, ORM code → orm-reviewer

Especialista em otimização de queries SQL, design de banco de dados e performance tuning para PostgreSQL, MySQL e SQLite

Manages LibSQL/Turso database schemas with Zod validation, creates migrations, and ensures type-safe database operations. Use when creating database tables, writing migrations, or implementing schema validation.

Use this skill when creating or updating DAG configurations (dags.yaml), schema.yaml, and metadata.yaml files for BigQuery tables. Handles creating new DAGs when needed and coordinates test updates when queries are modified (invokes sql-test-generator as needed). Works with bigquery-etl-core, query-writer, and sql-test-generator skills.

Expert guidance for designing, optimizing, and maintaining database schemas for SQL and NoSQL systems. Use when creating new databases, optimizing existing schemas, planning migrations, implementing security policies, or ensuring GDPR compliance. Covers normalization, indexing, data types, relationships, performance optimization, and audit logging.