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,457–3,480 of 4,315 skills

DagsterADagster is a data pipeline orchestrator built around the concept of software-defined assets. Learn to define assets, ops, jobs, schedules, sensors, and resources for building maintainable data platforms.databasespythongoVotes: 0GitHub stars: 142
D1 DatabaseABuild serverless applications with Cloudflare D1 — SQLite at the edge. Use when someone asks to "serverless database", "Cloudflare D1", "SQLite at the edge", "database for Workers", "edge database", or "serverless SQL". Covers schema setup, queries, migrations, Workers integration, and Drizzle ORM.databasestypescriptgoVotes: 0GitHub stars: 142
ConvexAAssists with building real-time reactive backends using Convex. Use when creating databases with automatic client sync, reactive queries, file storage, scheduled functions, or full-text and vector search. Trigger words: convex, reactive backend, real-time database, useQuery, useMutation, convex functions, convex schema.databasestypescriptgoVotes: 0GitHub stars: 142
Aws RdsBManage Amazon RDS for fully managed relational databases. Provision MySQL, PostgreSQL, and Aurora instances with automated backups and patching. Configure read replicas for scaling, snapshots for recovery, and Aurora Serverless for variable workloads.databasesgobashVotes: 0GitHub stars: 142
Aws DynamodbABuild with Amazon DynamoDB for fast, scalable NoSQL storage. Design tables with partition and sort keys, create GSI and LSI for flexible queries, enable streams for change data capture, and apply single-table design patterns for efficient data modeling.databasespythongoVotes: 0GitHub stars: 142
AlembicAManage database migrations for SQLAlchemy with Alembic. Use when a user asks to version database schemas, autogenerate migration scripts from models, run or roll back migrations, set up async SQLAlchemy migrations, or handle schema changes safely in production.databasespythongoVotes: 0GitHub stars: 142
AirflowAApache Airflow is a platform for programmatically authoring, scheduling, and monitoring workflows. Learn to write DAGs, use operators, set up connections, configure scheduling, and deploy with Docker Compose.databasespythongoVotes: 0GitHub stars: 142
AirbyteAYou are an expert in Airbyte, the open-source data integration platform with 300+ pre-built connectors. You help developers sync data from SaaS tools, databases, and APIs into data warehouses and lakes — handling incremental syncs, CDC (Change Data Capture), schema evolution, and error recovery for production data pipelines.databasespythongoVotes: 0GitHub stars: 142
ActivepiecesAActivepieces is an open-source workflow automation platform with a visual builder, 400+ integrations ("pieces"), code steps, branching, loops, and webhooks. Use when a user asks to self-host a Zapier or n8n alternative, automate workflows with a no-code builder, build a custom integration piece, or set up open-source business automation.databasestypescriptrustVotes: 0GitHub stars: 142
Drizzle Orm ExpertAExpert in Drizzle ORM for TypeScript — schema design, relational queries, migrations, and serverless database integration. Use when building type-safe database layers with Drizzle.databasestypescriptbashVotes: 0GitHub stars: 30,495
Tone TokenADesign or refactor a design token architecture — naming, tiers, and coverage.databasesbashVotes: 0GitHub stars: 71
Pave EnvASet up local development environments — devcontainers, Docker Compose, one-command setup, dev/prod parity. Use when asked to "set up dev environment", "devcontainer", "docker compose for dev", "local development setup", or "one command to run".databasespythongoVotes: 0GitHub stars: 71
Lens MetricsAProduce a complete metrics definition doc — metric name, formula, data source, segmentation, SQL or event tracking spec, and what good/bad looks like. Given a product area, outputs the full metrics spec. Use when asked to "define KPIs", "metrics framework", "what should we measure", "north star metric", or "instrument this feature".databasesgobashVotes: 0GitHub stars: 71
Hue TokenAAudit or refactor a design token system for color — naming, structure, and coverage.databasesbashVotes: 0GitHub stars: 71
Flux SchemaADesign and build database schema — tables, columns, types, indexes, constraints, relationships. Given a domain description, output the schema and write the files. Use when asked to "design schema", "database design", "create tables", or "data model".databasesbashsqlVotes: 0GitHub stars: 71
Flux ReconADatabase reconnaissance — full inventory of schema, migrations, data volume, backups, connection pooling, and query patterns. Use when asked to "assess this database", "understand the schema", or "database health check".databasesbashsqlVotes: 0GitHub stars: 71
Flux QueryAOptimize slow database queries — analyze execution plans, add indexes, rewrite queries. Use when asked about "slow query", "optimize SQL", "query performance", or "explain this query".databasesbashsqlVotes: 0GitHub stars: 71
Flux MigrateABuild zero-downtime database migrations — forward SQL, rollback SQL, deployment sequence. Use when asked to "write migration", "schema change", "add column", "rename table", "drop column", or "migrate safely".databasesgobashVotes: 0GitHub stars: 71
Flux HealthAData quality and pipeline health check — freshness, schema drift, null rates, orphaned records, pipeline status. Use when asked about "data quality check", "pipeline health", "is our data fresh", or "schema drift".databasesbashdatabaseVotes: 0GitHub stars: 71
Databricks LakebaseADatabricks Lakebase Postgres: projects, scaling, connectivity, Lakebase synced tables, and Data API. Use when asked about Lakebase databases, OLTP storage, or connecting apps to Postgres on Databricks.databasespythongoVotes: 0GitHub stars: 333
Databricks DbsqlADatabricks SQL (DBSQL) advanced features and SQL warehouse capabilities. This skill MUST be invoked when the user mentions: "DBSQL", "Databricks SQL", "SQL warehouse", "SQL scripting", "stored procedure", "CALL procedure", "materialized view", "CREATE MATERIALIZED VIEW", "pipe syntax", "|>", "geospatial", "H3", "ST_", "spatial SQL", "collation", "COLLATE", "ai_query", "ai_classify", "ai_extract", "ai_gen", "AI function", "http_request", "remote_query", "read_files", "Lakehouse Federation", "r...databasesgosqlVotes: 0GitHub stars: 333
Cache DesignADesign a caching strategy for an application — pattern selection, key design, TTL, and eviction policy.databasesbashtestingVotes: 0GitHub stars: 71
Atlas AdrAWrite an Architecture Decision Record — document what was decided, why, what alternatives were considered, and what trade-offs were accepted. Use when asked to "write an ADR", "document this decision", or "why did we choose X".databasesgobashVotes: 0GitHub stars: 71
Spine PerfAFind and fix performance bottlenecks — N+1 queries, missing indexes, sync bottlenecks, caching gaps. Use when asked "why is this slow", "performance issue", "optimize this endpoint", or "N+1 queries".databasespythongoVotes: 0GitHub stars: 71