GitHub
database-schema-guide
VaultCPA database schema reference with 50+ Prisma models, relationships, and query patterns. Use when working with database models, designing features, or understanding data structure.
☆ 0View 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
slow-query-detector
Detect slow queries and performance issues in Entity Framework Core codebases. Use when analyzing database performance, finding N+1 queries, identifying missing indexes, reviewing repository patterns, or optimi...
☆ 0View skill
GitHub
database-migration
Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data transformations...
☆ 0View skill
GitHub
postgresql-table-design
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
☆ 0View skill
GitHub
sql-optimization-patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or...
☆ 0View skill
GitHub
pyspark-test-generator
Generate comprehensive PySpark-based data quality validation tests for Databricks tables. Use when creating automated tests for data completeness, accuracy, consistency, and conformity, or when user mentions te...
☆ 0View skill
GitHub
databricks-query
Execute SQL queries against Databricks using the DBSQL MCP server. Use when querying Unity Catalog tables, running SQL analytics, exploring Databricks data, or when user mentions Databricks queries, SQL executi...
☆ 0View skill
GitHub
duckdb-backup
Comprehensive DuckDB database backup toolkit supporting both file-based (cp) and native (ATTACH+COPY) backup approaches. Use when you need to backup DuckDB databases locally or to remote storage, create daily s...
☆ 0View skill
GitHub
backend-models
Define database models and schemas with proper data types, constraints, relationships, and validation rules for PostgreSQL (Supabase/Bun.sql) and Firestore (Firebase). Use this skill when creating or modifying...
☆ 0View skill
GitHub
backend-queries
Write efficient and secure database queries following best practices for SQL injection prevention, N+1 query optimization, and performance for PostgreSQL (Bun.sql, Prisma, Supabase) and Firestore. Use this skil...
☆ 0View skill
GitHub
backend-migrations
Create and manage database migrations following best practices for reversibility, zero-downtime deployments, and version control. Use this skill when creating migration files, modifying database schemas, adding...
☆ 0View skill
GitHub
db-architect
Expert database architecture including schema design, partitioning, replication, and performance optimization
☆ 0View skill
GitHub
database-expert
Expert database development including SQL, NoSQL, schema design, query optimization, and migrations
☆ 0View skill
GitHub
neon-db-setup
Set up Neon Serverless PostgreSQL database, configure connection strings, manage database credentials, and integrate with SQLModel ORM. Use when setting up database infrastructure for Phase 2 or configuring dat...
☆ 0View skill
GitHub
database-seeding
Generate and manage database seed data for development and testing. Use when developers need realistic test data, database migrations with initial data, or automated seeding for local environments. Supports Pos...
☆ 0View skill
GitHub
new-db-schema
Create new database tables with Drizzle ORM schemas and Valibot validation. 使用 Drizzle ORM 创建新的数据库表模式和 Valibot 验证。 Use when: - Adding new database tables - Creating entity schemas - User mentio...
☆ 0View skill
GitHub
databases
RDBMS access patterns for DuckDB, MySQL (keycloak), PostgreSQL (dw, x3rocs), SQL Server (sage1000, x3), and DBISAM (Exportmaster) using ODBC and native drivers
☆ 0View skill
GitHub
lockplane
Use Lockplane for safe database schema management - define schemas in .lp.sql files, validate, and apply with shadow DB testing
☆ 0View skill
GitHub
supabase-database-query
Execute SQL queries, migrations, and RLS policies on Supabase database using MCP tools
☆ 0View skill
GitHub
db-schema-manager
Manages all database table schemas for the AI Trading System. Use when: creating tables, validating data before insert/update, checking schema compatibility, generating migrations, or when user mentions data...
☆ 0View skill
GitHub
minimal-modeling
Use when designing database schemas from business requirements, translating vague requirements into concrete SQL definitions, or validating database designs with non-technical stakeholders. Provides a systemati...
☆ 0View skill
GitHub
rwsdk-database-do
Use when working with rwsdk/db for SQLite Durable Objects - covers setup with migrations, type-safe queries with Kysely, CRUD operations, joins, seeding, and migration rollback handling in Cloudflare Workers en...
☆ 0View skill
GitHub
numpy-indexing
Advanced indexing techniques including slicing, fancy indexing, and boolean masks, along with memory implications of views vs. copies. Triggers: indexing, slicing, fancy indexing, boolean mask, np.where, np.ix_...
☆ 0View 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...
☆ 0View 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.