sql-databases
11
mysql-tools
MySQL 数据库工具集，用于连接数据库实例、列出所有表、查看表结构、执行 SQL 查询等操作。当需要操作 MySQL 数据库、查询数据、分析表结构时使用此技能。支持通过命令行参数指定 host、port、user、password、database 等连接信息，可代替 mysql mcp 服务使用。支持 Windows、macOS 和 Linux 平台。
huangzt
databases
sorting
stars
current ordering strategy
query
all entries
refine the visible subset
sql-databases
11
sqlite-tools
SQLite 数据库工具集，用于操作 SQLite 数据库文件。支持 .db、.sqlite、.sqlite3、.vscdb 等常见扩展名。无需额外安装依赖，使用 Python 内置 sqlite3 模块。支持 Windows、macOS 和 Linux 平台。
huangzt
databases
sql-databases
11
database-migrations
Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate).
marshall0524
databases
sql-databases
11
database-schema-designer
Design relational database schemas from requirements and generate migrations, TypeScript/Python types, seed data, RLS policies, and indexes. Handles multi-tenancy, soft deletes, audit trails, versioning, and polymorphic associations.
seaworld008
databases
sql-databases
11
alpha-coredatabase-advisor
Advises on database selection, schema design, indexing, query optimization, and migration. Covers SQL, NoSQL, Graph, Columnar, Key-Value, Time Series, NewSQL, Vector, Serverless, Data Warehouse, Embedded, Multi-Model, Streaming, and Decentralized databases. 100+ database technologies including PostgreSQL, MySQL, MongoDB, Redis, Kafka, Neo4j, Cassandra, ClickHouse, DynamoDB, CockroachDB, Pinecone, Snowflake, and ORMs (Prisma, Drizzle, SQLAlchemy, GORM, Diesel, EF Core, Hibernate). Use when selecting databases, designing schemas, optimizing queries, or planning migrations.
rnavarych
databases
sql-databases
11
data-write-query
Write optimized SQL for your dialect with best practices
kevinlin
databases
sql-databases
11
bigquery-optimization
Use when writing, reviewing, or optimizing BigQuery SQL, asking about BigQuery best practices, working with .sql files targeting BigQuery, or troubleshooting slow/expensive BigQuery queries. Symptoms: high slot consumption, full table scans, expensive joins, slow queries, high bytes billed.
justvinhhere
databases
sql-databases
11
bigquery-query-generation
Use when generating BigQuery SQL from natural language descriptions, converting queries from other SQL dialects to BigQuery, writing new BigQuery queries from scratch, or when the user describes what data they need and expects SQL output. Triggers on: "write me a query", "generate SQL", "how do I query", "convert this to BigQuery", "I need to get data from", "create a query".
justvinhhere
databases
sql-databases
11
sequelize-patterns
Sequelize Node.js ORM for SQL databases. Use for database models, migrations, associations, queries, transactions, validations, hooks, and working with PostgreSQL, MySQL, MariaDB, SQLite, SQL Server.
joneqian
databases
sql-databases
11
node-sqlite-patterns
Database patterns for better-sqlite3 with WAL mode. Query optimization, schema design, and migration patterns for the tracker's SQLite layer.
moodler
databases
sql-databases
11
role-databaserelational-databases
Deep operational guide for 20 relational/SQL databases. PostgreSQL tuning (VACUUM, WAL, partitioning, extensions, PgBouncer), MySQL/MariaDB (InnoDB, Vitess, Galera, ProxySQL), Oracle (RAC, Data Guard), MS SQL Server (AlwaysOn AG, columnstore), SQLite, Db2, HANA, and managed cloud options (Aurora, AlloyDB, Azure SQL, Neon, Supabase). Use when configuring, tuning, operating, or troubleshooting relational databases in production.
rnavarych
databases
sql-databases
11
role-databaseschema-design
Database schema design principles and patterns. Normalization (1NF through 5NF/BCNF), strategic denormalization for read performance, multi-tenancy schema patterns (shared schema, schema-per-tenant, database-per-tenant), primary key strategies (UUID v7, ULID, KSUID, Snowflake ID, BIGSERIAL, CUID2, NanoID), soft delete patterns, temporal tables (SCD Type 1/2/3/4/6), audit trails, schema evolution (expand-contract pattern), naming conventions, data type best practices, and anti-patterns to avoid (EAV, polymorphic associations, god tables). Use when designing new schemas, reviewing existing schema design, planning schema migrations, or choosing PK strategies.
rnavarych
databases
sql-databases
11
tumiki-prisma-schema-changes
Prismaスキーマ変更の安全な手順ガイド。データベーススキーマの追加・変更・ マイグレーション実行時に使用。「テーブル追加」「カラム追加」「マイグレーション」 などのリクエスト時にトリガー。
rayven122
databases
sql-databases
11
platform-database
SQL database design, query optimization, and migration safety. Use when writing queries, designing schemas, or planning database migrations.
ravnhq
databases
sql-databases
11
tech-drizzle
Drizzle ORM typesafe schema design, relational queries, prepared statements, migrations, and transactions. Use when working with Drizzle ORM, writing database queries, managing migrations, or optimizing query performance with prepared statements.
ravnhq
databases
sql-databases
11
sql-server
Use SQL Server for enterprise relational data storage with advanced features, high availability, and Windows integration.
hivellm
databases
sql-databases
11
postgresql
Use PostgreSQL for relational data storage with ACID compliance, transactions, and advanced features.
hivellm
databases
sql-databases
11
using-drizzle-queries
Write type-safe database queries with Drizzle ORM. Covers select, insert, update, delete, relational queries, and adding new tables.
andrelandgraf
databases
sql-databases
11
preferences-data-modeling
Data modeling conventions including Arrow-based columnar interchange, DuckDB/DuckLake lakehouse patterns, SQLMesh transformations, and scientific data contracts. Load when designing database structures, data pipelines, cross-language analytics, or data relationships.
cameronraysmith
databases