GitHub
python-peewee
Patterns for using Peewee ORM with DatabaseProxy and scoped connections/transactions. Use when setting up DatabaseProxy, managing connection_context/atomic blocks, or writing tests with SQLite.
☆ 2View skill
tools sql databases AI Skills
Discover tools sql databases skills, compare source repositories and read the instructions for each workflow.
Categories: tools sql databases
tools sql databases Clear filters
Browse skills
GitHub
database-migration
DBマイグレーション支援。スキーマ変更やマイグレーション作成依頼時に使用。ORM自動検出、命名規則確認、既存マイグレーションとの整合性を検証。
☆ 2View skill
GitHub
prisma-setup
Prisma ORM configuration and patterns. Use when setting up database access with Prisma.
☆ 2View skill
GitHub
query-optimization
Database query optimization strategies. Use when improving query performance.
☆ 2View skill
GitHub
drizzle-setup
Drizzle ORM configuration and patterns. Use as a lightweight alternative to Prisma.
☆ 2View skill
GitHub
migration-strategies
Database migration best practices and strategies. Use when managing schema changes.
☆ 2View skill
GitHub
spacetimedb-reference
SpacetimeDB multiplayer development patterns, schema changes, subscriptions, and performance optimization
☆ 2View skill
GitHub
rails-migrations
This skill should be used when the user asks about "migrations", "database schema", "create_table", "add_column", "remove_column", "add_index", "foreign keys", "db:migrate", "db:rollback", "schema.rb", "change_...
☆ 2View skill
GitHub
activerecord
This skill should be used when the user asks about "ActiveRecord", "database queries", "associations", "validations", "migrations", "scopes", "callbacks", "N+1 queries", "eager loading", "includes", "joins", "e...
☆ 2View skill
GitHub
database-design
Production-grade database design skill for SQL/NoSQL selection, schema design, indexing, and query optimization
☆ 2View skill
GitHub
mysql
MySQL database administration and development
☆ 2View skill
GitHub
transactions
Database transactions, ACID properties, and concurrency control
☆ 2View skill
GitHub
query-optimization
SQL query optimization and performance tuning
☆ 2View skill
GitHub
migrations
Database schema migrations and version control
☆ 2View skill
GitHub
data-analysis-sql
SQL for data analysis with exploratory analysis, advanced aggregations, statistical functions, outlier detection, and business insights. 50+ real-world analytics queries.
☆ 2View skill
GitHub
postgresql
PostgreSQL administration and setup including installation, configuration, backup/recovery, replication, and high-availability. Learn production PostgreSQL operations.
☆ 2View skill
GitHub
data-warehouse
Data warehouse design mastery with star schema, dimensional modeling, fact/dimension tables, slowly changing dimensions, and enterprise best practices. Complete schema examples included.
☆ 2View skill
GitHub
sql-fundamentals
Master SQL fundamentals including SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP operations. Learn data types, WHERE clauses, ORDER BY, GROUP BY, and basic joins.
☆ 2View skill
GitHub
php-database
PHP database mastery - PDO, Eloquent, Doctrine, query optimization, and migrations
☆ 2View skill
GitHub
writing-queries
Component skill for systematic SQL query development in DataPeeker analysis sessions
☆ 2View skill
GitHub
using-sqlite
Use when working with SQLite databases in DataPeeker analysis sessions - querying data, importing CSVs, exploring schemas, formatting output, or optimizing performance. Provides task-oriented guidance for effec...
☆ 2View skill
GitHub
detect-foreign-keys
Identify foreign key relationships between tables using heuristics, value overlap analysis, and referential integrity checks
☆ 2View skill
GitHub
database-assistant
Activates when user needs help with database design, SQL queries, migrations, or ORM usage. Triggers on "database schema", "SQL query", "migration", "optimize query", "foreign key", "index", "normalize", "ORM",...
☆ 2View skill
GitHub
sql-analysis
Master SQL for data analysis with complex queries, joins, aggregations, window functions, and query optimization.
☆ 2View 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.