🗄️SQL and Databases Skills
Browse the best SQL and Databases skills for Claude Code, Codex, Cursor and other AI agents.
1,171 skills · Page 7 of 49
pg-data
★ 70Generate safe, read-only PostgreSQL queries from natural language. Use when users need to query blog_small, ecommerce_medium, or saas_crm_large databases. Supports query generation, execution, and result analysis with confidence scoring.
database-design
★ 62Database design patterns including normalization, indexing, query optimization, and PostgreSQL best practices. Use when designing schemas, optimizing queries, or planning migrations.
data-migration
★ 49Plan and execute database migrations, data transformations, and system migrations safely with rollback strategies and data integrity validation. Use when migrating databases, transforming data schemas, moving between database systems, implementing versioned migrations, handling data transformations, ensuring data integrity, or planning zero-downtime migrations.
convex-backend
★ 49Build real-time, reactive backend applications with Convex using TypeScript queries, mutations, and actions with automatic reactivity and optimistic updates. Use when building real-time collaborative applications, implementing reactive data synchronization, writing serverless backend functions, creating queries that auto-update, implementing mutations with transactional guarantees, handling file uploads with Convex storage, implementing authentication with Convex Auth, designing reactive database schemas, or building applications requiring instant data synchronization.
elixir-ecto-patterns
★ 47Use when Elixir Ecto patterns including schemas, changesets, queries, and transactions. Use when building database-driven Elixir applications.
ecto-schemas
★ 47Use when defining and working with Ecto schemas including field types, associations, and embedded schemas. Use when modeling database entities in Elixir.
ecto-changesets
★ 47Use when validating and casting data with Ecto changesets including field validation, constraints, nested changesets, and data transformation. Use for ensuring data integrity before database operations.
django-orm-patterns
★ 47Use when Django ORM patterns with models, queries, and relationships. Use when building database-driven Django applications.
ecto-query-patterns
★ 47Use 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.
database-migration
★ 46Create database migration with schema changes and rollback. Auto-invoke when user says "create migration", "add table", "modify schema", or "change database".
prisma
★ 38Prisma ORM patterns including Prisma Client usage, queries, mutations, relations, transactions, and schema management. Use when working with Prisma database operations or schema definitions.
spring-data-neo4j
★ 38Expert in Spring Data Neo4j integration patterns for graph database development. Use when working with Neo4j graph databases, node entities, relationships, Cypher queries, reactive Neo4j operations, or Spring Data Neo4j repositories. Essential for graph data modeling, relationship mapping, custom queries, and Neo4j testing strategies.
aws-sdk-java-v2-dynamodb
★ 38Amazon DynamoDB patterns using AWS SDK for Java 2.x. Use when creating, querying, scanning, or performing CRUD operations on DynamoDB tables, working with indexes, batch operations, transactions, or integrating with Spring Boot applications.
mongodb
★ 37Work with MongoDB databases using best practices. Use when designing schemas, writing queries, building aggregation pipelines, or optimizing performance. Triggers on MongoDB, Mongoose, NoSQL, aggregation pipeline, document database, MongoDB Atlas.
discover-data
★ 33Automatically discover data pipeline and ETL skills when working with ETL. Activates for data development tasks.
discover-database
★ 33Automatically discover database skills when working with SQL, PostgreSQL, MongoDB, Redis, database schema design, query optimization, migrations, connection pooling, ORMs, or database selection. Activates for database design, optimization, and implementation tasks.
sql-expert
★ 32SQL query optimization, indexing strategies, and EXPLAIN analysis for Lemline's multi-database architecture (PostgreSQL, MySQL, H2). Use when debugging slow queries, designing indexes, optimizing outbox patterns, or ensuring cross-database compatibility.
db-migrate
★ 31Create database migrations using Drizzle Kit. Use when adding/modifying tables, columns, or indexes. Ensures schema.ts and migrations stay in sync.
postgresql-psql
★ 31Comprehensive guide for PostgreSQL psql - the interactive terminal client for PostgreSQL. Use when connecting to PostgreSQL databases, executing queries, managing databases/tables, configuring connection options, formatting output, writing scripts, managing transactions, and using advanced psql features for database administration and development.
supabase
★ 29Database, auth, and backend expertise for Supabase operations in [PROJECT_NAME]
nette-database
★ 27Invoke before writing database queries or working with Selection API, ActiveRow in Nette.
supabase-migration
★ 26Activates when working with database migrations, RLS policies, or Supabase schema changes.Use this skill for: creating migrations, writing RLS policies, handling PostGIS geometry,creating indexes, managing materialized views, and generating TypeScript types.Keywords: migration, supabase, RLS, policy, PostGIS, geometry, schema, table, index
alembic
★ 26Comprehensive Alembic database migration management for customer support systems
postgresql-database-administration
★ 26Comprehensive PostgreSQL database administration skill for customer support tech enablement, covering database design, optimization, performance tuning, backup/recovery, and advanced query techniques