This skill should be used when the user asks to "add a database table", "create a new context", "query the database", "add a field to a schema", "validate form input", "fix N+1 queries", "preload this association", "separate these concerns", or mentions Repo, changesets, migrations, Ecto.Multi, has_many, belongs_to, transactions, query composition, or how contexts should talk to each other.
Analyse whether a SQL query is portable across database implementations using sqlglot transpilation. Use this skill when checking SQL compatibility, cross-database portability, dialect differences, or when reviewing SQL on FHIR ViewDefinition queries for implementation-specific issues. Trigger keywords include "sql portability", "dialect", "cross-database", "transpile", "compatible", "portable SQL", "database compatibility".
Use when implementing Apollo caching strategies including cache policies, optimistic UI, cache updates, and normalization.
Use when working with SQLite databases in Bun. Covers Bun's built-in SQLite driver, database operations, prepared statements, and transactions with high performance.
Use when defining data structures using Ecto schemas including fields, associations, embedded schemas, and schema metadata. Use for modeling domain data in Elixir applications.
Use when querying data with Ecto.Query DSL including where clauses, joins, aggregates, preloading, and query composition. Use for building flexible database queries in Elixir applications.
Use when defining and working with Ecto schemas including field types, associations, and embedded schemas. Use when modeling database entities in Elixir.
Use when Django ORM patterns with models, queries, and relationships. Use when building database-driven Django applications.
Use when lINQ (Language Integrated Query) with query and method syntax, deferred execution, expression trees, and performance optimization.
Use when lINQ query and method syntax, deferred execution, and performance optimization. Use when querying collections in C#.
Use when Elixir Ecto patterns including schemas, changesets, queries, and transactions. Use when building database-driven Elixir applications.
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
Countries, states, cities, ResolveLocationAction, Location base model, LocationType enum, geocoding, and location-level Redis data.
TanStack Query (React Query) best practices for data fetching, caching, mutations, and server state management. Activate when building data-driven React applications with server state.
Upgrade Next.js to the latest version following official migration guides and codemods. Use when upgrading Next.js versions, running codemods, or migrating between major releases.
Vercel storage expert guidance — Blob, Edge Config, and Marketplace storage (Neon Postgres, Upstash Redis). Use when choosing, configuring, or using data storage with Vercel applications.
Changing database schema with Kysely migrations across SQLite, PostgreSQL, and MariaDB.
Guide UNION-based SQL injection exploitation during authorized penetration testing.
Database service enumeration and quick-win access checks for MSSQL, MySQL, PostgreSQL, Oracle, MongoDB, and Redis. Checks default/empty passwords, unauthenticated access, and command execution capabilities. Use after network-recon identifies database ports.
Guide NoSQL injection exploitation during authorized penetration testing.
Guide stacked query SQL injection and second-order injection exploitation during authorized penetration testing.
Database schema and migration workflow. Use when modifying database schemas in tools/atlas/ or SQLC queries in tools/sqlc/.
