Databases

SQL, NoSQL, schema design, migrations, ORMs, and database operations

skills in category: 4,315
pages available: 180

Security grades appear on each card once the skill has been scanned. Newly imported skills may briefly show without a grade until the backfill job runs.

Open in full browser

Browse databases skills

Showing 3,553–3,576 of 4,315 skills

Obsidian BasesACreate and edit Obsidian Bases (.base files) with views, filters, formulas, and summaries. Use when working with .base files, creating database-like views of notes, or when the user mentions Bases, table views, card views, filters, or formulas in Obsidian.databasesexpressgitVotes: 0GitHub stars: 3
DatabaseADiagnose and fix slow database queries. Runs EXPLAIN ANALYZE, identifies missing indexes, eliminates N+1 ORM patterns, and provides exact CREATE INDEX statements.databasesgosqlVotes: 0GitHub stars: 2
Rails ModelsAActiveRecord patterns, migrations, validations, callbacks, associationsdatabasesgorubyVotes: 0GitHub stars: 14
SupabaseAThis skill should be used when the user asks to "integrate Supabase", "set up Supabase auth", "write RLS policies", "use Supabase storage", "subscribe to realtime changes", or mentions "supabase", "supabase auth", "RLS", "row level security", "supabase client", "supabase storage", "realtime", "edge function", "supabase migration". Provides Supabase best practices for Next.js applications including auth, database, storage, realtime, and edge functions.databasestypescriptrustVotes: 0GitHub stars: 3
Prisma OrmAPrisma ORM expertise for schema design, migrations, client usage, and deployment. Use when writing Prisma schemas, creating migrations, querying with Prisma Client, defining relations, or deploying database changes. Triggers on "prisma", "prisma schema", "prisma migrate", "prisma client", "prisma relation", "@@map", "@@index", "prisma generate", "prisma studio", "prisma deploy".databasestypescriptbashVotes: 0GitHub stars: 3
Postgresql ExpertAThis skill should be used when the user asks to 'write a PostgreSQL query', 'configure postgresql.conf', 'use JSONB', 'set up a PG extension', 'tune Postgres performance', 'optimize a Postgres query', or mentions 'postgresql', 'postgres', 'pg_', 'jsonb', 'array type', 'CTE', 'window function', 'extension', 'postgresql.conf', 'pg_stat', 'vacuum', 'WAL'. Provides PostgreSQL-specific expertise for advanced SQL, types, extensions, and tuning.databasesgosqlVotes: 0GitHub stars: 3
Mysql ExpertAThis skill should be used when the user asks to "write a MySQL query", "configure my.cnf", "choose a storage engine", "tune MySQL performance", "set up MySQL replication", or mentions "mysql", "mariadb", "innodb", "my.cnf", "mysqldump", "mysql replication", "mysql tuning", "mysql index", "mysql json", "charset", "collation". Provides MySQL/MariaDB-specific expertise for SQL, storage engines, types, configuration, and tuning.databasesgosqlVotes: 0GitHub stars: 3
Database OptimizerAThis skill should be used when the user asks to "optimize a database query", "analyze a slow query", "review EXPLAIN output", "design indexes", "fix N+1 queries", or mentions "query optimization", "slow query", "EXPLAIN", "index", "performance", "query plan", "table scan", "index tuning", "N+1", "query analysis". Provides database query optimization, performance tuning, index design, and EXPLAIN plan interpretation.databasesgosqlVotes: 0GitHub stars: 3
Database DesignerAThis skill should be used when the user asks to "design a database schema", "normalize a data model", "plan a migration strategy", "define table relationships", "review an ERD", or mentions "schema design", "database design", "data model", "ERD", "normalization", "migration strategy", "table design", "foreign key", "relationship". Provides database schema design expertise including normalization, relationship patterns, naming conventions, and migration strategies.databasessqldatabaseVotes: 0GitHub stars: 3
Data Model DesignADimensional modeling and schema design for data products. Star schema patterns, slowly changing dimensions, denormalization decisions, and architecture decision records. Use when designing data models, reviewing schema designs, choosing between normalization strategies, or when someone asks "how should I model this data?" or "should I denormalize?" For OMOP CDM patterns specifically, see healthcare-data-domain.databasesgodatabaseVotes: 0GitHub stars: 3
Database MigrationsADatabase 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).databasestypescriptpythonVotes: 0GitHub stars: 53
Mongodb MeanAMongoDB database architecture for MEAN stack apps. Use when designing collections, schemas, indexes, relationships, and data modeling with Mongoose ODM.databasesgodatabaseVotes: 0GitHub stars: 3
Clickhouse IoAClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.databasestypescriptgoVotes: 0GitHub stars: 53
Sql ExplainerAPaste a SQL query and get a plain English explanation of what it does.databasessqldatabaseVotes: 0GitHub stars: 3,946
Migration ImmutabilityADetermine whether an existing migration can change and implement corrective migrations safely.databasesgoVotes: 0GitHub stars: 56
DatabasesADesign schemas, write queries for MongoDB and PostgreSQL. Use for database design, SQL/NoSQL queries, aggregation pipelines, indexes, migrations, replication, performance optimization, psql CLI.databasespythongoVotes: 0GitHub stars: 6
Tanstack RouterAType-safe routing for React and Solid applications with first-class search params, data loading, and seamless integration with the React ecosystem.databasestypescriptgoVotes: 0GitHub stars: 31
Tanstack PacerAFramework-agnostic debouncing, throttling, rate limiting, queuing, and batching utilities.databasestypescriptgoVotes: 0GitHub stars: 31
Tanstack FormAHeadless, performant, and type-safe form state management for TS/JS, React, Vue, Angular, Solid, Lit, and Svelte.databasestypescriptbashVotes: 0GitHub stars: 31
Tanstack DbAReactive client-first store for your API with collections, live queries, and optimistic mutations.databasestypescriptgoVotes: 0GitHub stars: 31
Tanstack CliAProject scaffolding CLI with 30+ integrations, custom templates, and MCP server for AI agents.databasesbashreactVotes: 0GitHub stars: 31
MouserBSearch Mouser Electronics for electronic components — secondary source for prototype orders. Find parts, check pricing/stock, download datasheets, analyze specifications. Use with KiCad for BOM creation and part selection. Also supports batch MPN-list seeding (`--mpn-list`) for bulk datasheet workflows without a KiCad project. Use this skill when the user specifically mentions Mouser, when DigiKey is out of stock or has worse pricing, when comparing prices across distributors, or when searchi...databasespythongoVotes: 0GitHub stars: 1,339
LcscASearch LCSC Electronics for electronic components — find parts by LCSC number (Cxxxxx) or MPN, check stock/pricing, download datasheets, analyze specifications. Sister company to JLCPCB, same parts library. Sync and maintain a local datasheets directory for a KiCad project, or use batch MPN-list seeding (`--mpn-list`) for bulk workflows without a project. No API key needed — uses the free jlcsearch community API. Use this skill when the user mentions LCSC, JLCPCB parts library, JLCPCB assembl...databasespythongoVotes: 0GitHub stars: 1,339
Altimate CodeADelegates data engineering tasks to altimate-code, a specialized CLI agent with 100+ purpose-built data tools — SQL analysis, column-level lineage, dbt build/test/run, warehouse profiling, FinOps, and connectivity to Snowflake, BigQuery, Redshift, Databricks, Postgres, MySQL, DuckDB. Use this skill when the task needs live warehouse access, column lineage, multi-step data exploration, dbt builds against a real warehouse, or when the user explicitly invokes "altimate", "altimate-code", or "the...databasesbashsqlVotes: 0GitHub stars: 124