SQL

WHEN: Database schema review, table design, normalization, constraints, index planningWHAT: Normalization analysis + Constraint validation + Index strategy + Data types + Relationship designWHEN NOT: Query optimization → sql-optimizer, ORM code → orm-reviewer

Development skill for CaseMark's Court Recording Transcriber - an AI-powered application for transcribing court recordings with speaker identification, synchronized playback, search, and legal document exports. Built with Next.js 16, PostgreSQL, Drizzle ORM, wavesurfer.js, and Case.dev APIs. Use this skill when: (1) Working on or extending the court-record-transcriber codebase, (2) Integrating with Case.dev transcription APIs, (3) Working with audio playback/waveforms, (4) Building transcript export features, or (5) Adding speaker identification logic.

Database normalization for CSV files. Analyzes data structure, detects functional dependencies, and decomposes into normalized tables (1NF-BCNF). Outputs multiple CSV files, SQL DDL, and Mermaid ERD. Use when: (1) converting flat CSV data into relational database schema, (2) reducing data redundancy, (3) preparing denormalized exports for database import, (4) user mentions "normalize", "1NF/2NF/3NF/BCNF", "functional dependencies", or "database design".

Neon serverless Postgres with autoscaling, instant database branching, and zero-downtime deployments. Use when building serverless applications, implementing database branching for dev/staging, or deploying with Vercel/Netlify.

Design database schemas for PostgreSQL, Neon, Convex, or Supabase. Use when users need to create tables, define relationships, plan migrations, optimize indexes, or implement data models. Covers normalization, denormalization strategies, and platform-specific features.

Turn the model into a SQLAlchemy-focused Python coding agent for designing models, writing queries, debugging database issues, and integrating SQLAlchemy with Alembic and FastAPI in new or existing Python projects.

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.

Use when creating or editing marimo reactive Python notebooks. Covers cell structure, UI elements (mo.ui), reactivity, SQL integration, markdown, and deployment as apps. Triggers on .py notebook creation, marimo edit/run commands, reactive notebook development, or interactive data exploration. Extends python-development skill.

Background jobs with PgBoss for Wasp applications. Use when implementing async tasks, scheduled jobs, email queues, or background processing. Requires PostgreSQL database.

PROACTIVE skill - STOP and invoke BEFORE writing dbt SQL. Validates models against coding conventions for staging, integration, and warehouse layers. Covers naming, SQL structure, field conventions, testing, and documentation. CRITICAL - When about to write .sql files in models/, invoke this skill first, write second. Supports project-specific convention overrides and sqlfluff integration.

Presentation-focused Natural Language to SQL app with PPT-style visualizations.

Implement the repository pattern for database abstraction with sqlx, transactions, and retry logic. Use when building data access layers.

World-class data science skill for statistical modeling, experimentation, causal inference, and advanced analytics. Expertise in Python (NumPy, Pandas, Scikit-learn), R, SQL, statistical methods, A/B testing, time series, and business intelligence. Includes experiment design, feature engineering, model evaluation, and stakeholder communication. Use when designing experiments, building predictive models, performing causal analysis, or driving data-driven decisions.

Universal database operations skill for modern applications. Expert in SQLModel/SQLAlchemy patterns, async database operations, connection pooling, migrations, performance optimization, and multi-database support (PostgreSQL, MySQL, SQLite). Provides production-ready patterns for any database-driven application.

Execute SQL queries against Databricks using the DBSQL MCP server. Use when querying Unity Catalog tables, running SQL analytics, exploring Databricks data, or when user mentions Databricks queries, SQL execution, Unity Catalog, or data warehouse operations. Handles query execution, result formatting, and error handling.

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.

SQLMesh patterns for data transformation with column-level lineage and virtual environments. Use when building data pipelines that need advanced features like automatic DAG inference and efficient incremental processing.

AUTOMATICALLY run Codex review after writing security-sensitive code (auth, crypto, SQL) - get a second opinion from OpenAI Codex

Skill for Lead Generation and Email Marketing automation in n8n. Use for creating leads, scoring, enrichment, email campaigns, and nurturing sequences. Activate when working on lead capture forms, email workflows, MQL/SQL qualification, or marketing automation.

Garantir que testes de integração usem MySQL 9.5 via Testcontainers com isolamento, migrations e secrets corretos.