GitHub
transaction-management
Manage database transactions for data consistency. Use when implementing ACID compliance, handling concurrency, or managing transaction isolation levels.
☆ 84View skill
research sql databases AI Skills
Discover research sql databases skills, compare source repositories and read the instructions for each workflow.
Categories: research sql databases
research sql databases Clear filters
Browse skills
GitHub
data-migration-scripts
Create safe, reversible database migration scripts with rollback capabilities, data validation, and zero-downtime deployments. Use when changing database schemas, migrating data between systems, or performing l...
☆ 84View skill
GitHub
database-migration-management
Manage database migrations and schema versioning. Use when planning migrations, version control, rollback strategies, or data transformations in PostgreSQL and MySQL.
☆ 84View skill
GitHub
database-query-optimization
Improve database query performance through indexing, query optimization, and execution plan analysis. Reduce response times and database load.
☆ 84View skill
GitHub
postgres
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) checkin...
☆ 82View skill
GitHub
prisma
Prisma ORM and PostgreSQL database operations. Use when working with database schema, migrations, queries, or the @projectx/db package.
☆ 77View skill
GitHub
csharp-linq
Use when lINQ query and method syntax, deferred execution, and performance optimization. Use when querying collections in C#.
☆ 75View skill
GitHub
ecto-schema-patterns
Use when defining data structures using Ecto schemas including fields, associations, embedded schemas, and schema metadata. Use for modeling domain data in Elixir applications.
☆ 75View skill
GitHub
csharp-linq
Use when lINQ (Language Integrated Query) with query and method syntax, deferred execution, expression trees, and performance optimization.
☆ 75View skill
GitHub
django-orm-patterns
Use when Django ORM patterns with models, queries, and relationships. Use when building database-driven Django applications.
☆ 75View skill
GitHub
ecto-query-patterns
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.
☆ 75View skill
GitHub
ecto-schemas
Use when defining and working with Ecto schemas including field types, associations, and embedded schemas. Use when modeling database entities in Elixir.
☆ 75View skill
GitHub
elixir-ecto-patterns
Use when Elixir Ecto patterns including schemas, changesets, queries, and transactions. Use when building database-driven Elixir applications.
☆ 75View skill
GitHub
jutsu-bunbun-sqlite
Use when working with SQLite databases in Bun. Covers Bun's built-in SQLite driver, database operations, prepared statements, and transactions with high performance.
☆ 75View skill
GitHub
discover-database
Automatically discover database skills when working with SQL, PostgreSQL, MongoDB, Redis, database schema design, query optimization, migrations, connection pooling, ORMs, or database selection. Activates for d...
☆ 75View skill
GitHub
database
Database optimization, query tuning, migrations, and administration. Use for database performance issues, schema design, or operational tasks.
☆ 69View skill
GitHub
sql
Write SQL queries, optimize execution plans, and design schemas. Use for query optimization, complex joins, or database design.
☆ 69View skill
GitHub
prisma
Prisma ORM patterns including Prisma Client usage, queries, mutations, relations, transactions, and schema management. Use when working with Prisma database operations or schema definitions.
☆ 65View skill
GitHub
sql-ecosystem
This skill should be used when working with SQL databases, "SELECT", "INSERT", "UPDATE", "DELETE", "CREATE TABLE", "JOIN", "INDEX", "EXPLAIN", transactions, or database migrations. Provides comprehensive SQL pa...
☆ 65View skill
GitHub
symfonydoctrine-fetch-modes
Use when symfony doctrine fetch modes
☆ 61View skill
GitHub
symfonydoctrine-relations
Use when symfony doctrine relations
☆ 61View skill
GitHub
query-expert
Master SQL and database queries across multiple systems. Generate optimized queries, analyze performance, design indexes, and troubleshoot slow queries for PostgreSQL, MySQL, MongoDB, and more.
☆ 61View skill
GitHub
database-expert
Database performance optimization, schema design, query analysis, and connection management across PostgreSQL, MySQL, MongoDB, and SQLite with ORM integration. Use this skill for queries, indexes, connection po...
☆ 60View skill
GitHub
mongodb-expert
MongoDB document modeling, aggregation pipeline optimization, sharding strategies, replica set configuration, connection pool management, and indexing patterns. Use this skill for MongoDB-specific issues, NoSQL...
☆ 60View skill
The default order uses GitHub repository stars from our indexed data. Stars belong to the source repository and may be shared by multiple skills. They indicate repository interest, not skill installs or an independent quality score.