GitHub
prisma-patterns
Prisma ORM patterns - use for database access in Next.js, schema design, migrations, transactions, and relations
☆ 4View skill
blockchain sql databases AI Skills
Discover blockchain sql databases skills, compare source repositories and read the instructions for each workflow.
Categories: blockchain sql databases
blockchain sql databases Clear filters
Browse skills
GitHub
flyway-migrations
Flyway database migrations - use for schema changes, data migrations, version management, and PostgreSQL DDL
☆ 4View skill
GitHub
database-query-optimizer
Analyzes and optimizes database queries for PostgreSQL, MySQL, MongoDB with EXPLAIN plans, index suggestions, and N+1 query detection. Use when user asks to "optimize query", "analyze EXPLAIN plan", "fix slow q...
☆ 4View skill
GitHub
sql-injection-anti-pattern
Security anti-pattern for SQL Injection vulnerabilities (CWE-89). Use when generating or reviewing code that constructs database queries, builds SQL statements, or handles user input in database operations. Det...
☆ 4View skill
GitHub
database-optimization
Use when optimizing database queries, indexes, N+1 problems, slow queries, or analyzing query performance. Triggers on keywords like "slow query", "N+1", "index", "query optimization", "database performance", "...
☆ 4View skill
GitHub
databases
Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin). Use when designing database schemas, writing queri...
☆ 4View skill
GitHub
backend-dev-guidelines
Comprehensive backend development guide for Supabase Edge Functions + PostgreSQL. Use when working with Supabase (database, auth, storage, realtime), Edge Functions, PostgreSQL, Row-Level Security (RLS), Resend...
☆ 4View skill
GitHub
clickhouse-patterns
Use when designing ClickHouse table schemas, choosing MergeTree engines, optimizing slow queries (execution time > 1 second), or implementing batch INSERT patterns. Does NOT cover real-time streaming from messa...
☆ 4View skill
GitHub
sql-to-osc
SQL to OSC (Online Schema Change) conversion expert for Flyway migration scripts. Use when: (1) Converting SQL migration files to OSC format, (2) User mentions "OSC", "轉換 OSC", "osc.txt", or "Online Schema Ch...
☆ 4View skill
GitHub
psql
Run PostgreSQL queries and meta-commands via CLI
☆ 4View skill
GitHub
postgres-migrations
Write safe PostgreSQL migrations that avoid blocking reads/writes. Use when creating migrations, adding columns, indexes, constraints, or modifying tables. Based on Squawk linter rules.
☆ 3View skill
GitHub
postgresql
Works with PostgreSQL including queries, migrations, indexes, and performance tuning. Use when designing database schemas, writing SQL queries, optimizing performance, or managing PostgreSQL databases.
☆ 3View skill
GitHub
kysely
Implements Kysely type-safe SQL query builder with full TypeScript inference, migrations, and multi-database support. Use when building type-safe SQL queries, needing a lightweight ORM alternative, or wanting S...
☆ 3View skill
GitHub
planetscale
Implements PlanetScale serverless MySQL with branching workflows, non-blocking schema changes, and Prisma integration. Use when building apps with PlanetScale, implementing database branching, or needing server...
☆ 3View skill
GitHub
prisma
Provides type-safe database access with Prisma ORM including schema definition, migrations, queries, and relations. Use when setting up database connections, defining data models, writing queries, or managing d...
☆ 3View skill
GitHub
drizzle
Builds type-safe database applications with Drizzle ORM including schema definition, queries, relations, and migrations. Use when working with databases in TypeScript, defining schemas, writing type-safe querie...
☆ 3View skill
GitHub
sqlite
Integrates SQLite embedded database with Node.js using better-sqlite3 for synchronous operations or the native Node.js SQLite module. Use when building applications with local storage, embedded databases, or wh...
☆ 3View skill
GitHub
supabase-db
Implements Supabase PostgreSQL database with JavaScript client, Row Level Security, real-time subscriptions, and edge functions. Use when building apps with Supabase, implementing RLS policies, or needing real-...
☆ 3View skill
GitHub
turso
Implements Turso edge SQLite database with libSQL client, embedded replicas, and vector search. Use when building edge-first apps, implementing embedded databases, or needing SQLite with global replication.
☆ 3View skill
GitHub
dbc-schema
Generate Effect Schema definitions for WoW DBC tables. Use when adding new game data tables or updating existing schemas.
☆ 3View skill
GitHub
migration-helper
Guide safe database and code migrations with zero-downtime strategies.
☆ 3View skill
GitHub
duckdb
This skill should be used when users need to work with the DuckDB CLI for querying, analyzing, or transforming data. Use this skill for executing SQL queries, importing/exporting data, configuring DuckDB settin...
☆ 3View skill
GitHub
tuner
EXPLAIN ANALYZE分析、クエリ実行計画最適化、インデックス推奨、スロークエリ検出・修正。DBパフォーマンス改善、クエリ最適化が必要な時に使用。Schemaのスキーマ設計を補完。
☆ 3View skill
GitHub
schema
DBスキーマ設計・マイグレーション作成・ER図設計。データモデリングの専門家として、正規化、インデックス設計、リレーション定義を担当。
☆ 3View 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.