GitHub
query-optimization
Optimize database queries, add indexes, prevent N+1 queries, and improve query performance. Use when queries are slow, investigating database bottlenecks, or optimizing data access patterns.
☆ 17查看技能
tools database tools AI 技能
发现 tools database tools 相关 Skills，比较来源仓库和用途，查看适合你工作流的技能说明。
分类目录: tools database tools
tools database tools 清除筛选
全部技能
GitHub
database-migrations
Create, manage, and apply database migrations using Doctrine ORM (MySQL for this service). Use when modifying entities, adding fields, managing database schema changes, creating repositories, or troubleshooting...
☆ 16查看技能
GitHub
query-performance-analysis
Detect N+1 queries, analyze slow queries with EXPLAIN, identify missing indexes, and ensure safe online index migrations for MySQL/MariaDB. Use when optimizing query performance, preventing performance regressi...
☆ 16查看技能
GitHub
db-migration-check
Detect dangerous operations in database migrations before deployment
☆ 16查看技能
GitHub
config-seeder
Seed JSON configuration files into database. Use ONCE at BAZINGA session initialization, BEFORE spawning PM.
☆ 16查看技能
GitHub
db
Database operations for SQLite, PostgreSQL, and MySQL. Use for queries, schema inspection, migrations, and AI-assisted query generation.
☆ 16查看技能
GitHub
database-sqlite
SQLite best practices, connection management, and migration system for PolyFlup.
☆ 15查看技能
GitHub
sqlalchemy-postgres
Expert guidance for SQLAlchemy 2.0 + Pydantic + PostgreSQL. Use when setting up database layers, defining models, creating migrations, or any database-related work. Automatically activated for DB tasks.
☆ 15查看技能
GitHub
flyway-migration
Database migration patterns using Flyway with versioned SQL scripts
☆ 14查看技能
GitHub
activerecord
This skill should be used when the user asks to "write a migration", "add a column", "add column to table", "create an index", "add a foreign key", "set up associations", "fix N+1 queries", "optimize queries",...
☆ 14查看技能
GitHub
reset-dev-database
Reset the development MySQL database by copying the test scenario SQL dump to the Docker init directory, replacing the database name from memoWikisTest to memoWikis_dev, and reinitializing the MySQL container....
☆ 13查看技能
GitHub
database-design
Designs database schemas, data models, relationships, indexes, and migrations for relational, NoSQL, time-series, and warehouse databases. Covers normalization, denormalization, ETL optimization, event sourcing...
☆ 13查看技能
GitHub
sql-optimization
Analyzes and optimizes SQL queries for better performance, including index design, query rewriting, execution plan analysis, and database tuning. Covers PostgreSQL-specific optimizations, N+1 prevention, CTE/wi...
☆ 13查看技能
GitHub
database-migrations
How to create and use our alembic database migration tool. Use when making changes to models.py.
☆ 13查看技能
GitHub
agent-database-optimizer
Expert database optimizer specializing in query optimization, performance tuning, and scalability across multiple database systems. Masters execution plan analysis, index strategies, and system-level optimizati...
☆ 13查看技能
GitHub
database-schema-design
Design and optimize database schemas for SQL and NoSQL databases. Use when creating new databases, designing tables, defining relationships, indexing strategies, or database migrations. Handles PostgreSQL, MySQ...
☆ 12查看技能
GitHub
clone-database
Clone MySQL/PostgreSQL databases from remote servers to local machine. Use when user mentions cloning database from EC2/server to local, copying remote database, or pulling database from remote. Handles backup,...
☆ 11查看技能
GitHub
sql-cli
Token-efficient MySQL/PostgreSQL operations using mycli and native CLI tools (Windows/Mac/Linux compatible). Replaces Artisan Tinker for database queries with 87% token savings.
☆ 11查看技能
GitHub
database-architect
Expert database schema designer and Drizzle ORM specialist. Use when user needs database design, schema creation, migrations, query optimization, or Postgres-specific features. Examples - "design a database sch...
☆ 11查看技能
GitHub
database-design
Database schema design, migrations, query optimization, and ORM patterns. Use when designing database schemas, writing migrations, optimizing queries, or working with ORMs like SQLAlchemy or Django ORM.
☆ 10查看技能
GitHub
prisma-query-optimizer
Query optimization and N+1 detection
☆ 10查看技能
GitHub
schema-consistency-checker
Audits database schemas for naming conventions, type consistency, nullability patterns, and missing constraints. Provides violations report with recommended fixes. Use for "schema validation", "database linting...
☆ 10查看技能
GitHub
prisma-migration-assistant
Plans and executes safe Prisma schema migrations with data backfills, rollback strategies, and SQL preview. Handles complex schema changes including data transformations. Use for "Prisma migrations", "schema ch...
☆ 10查看技能
GitHub
sql-query-optimizer
Analyzes and optimizes SQL queries using EXPLAIN plans, index recommendations, query rewrites, and performance benchmarking. Use for "query optimization", "slow queries", "database performance", or "EXPLAIN ana...
☆ 10查看技能
默认按已收录数据中的 GitHub 仓库 Stars 排序。Stars 属于来源仓库，同一仓库的多个技能可能共享相同数值；它反映仓库关注度，不代表单个技能的安装量或质量评分。