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 745–768 of 4,315 skills

SqlalchemyAThe standard Python SQL toolkit and ORM — 2.x style only. Covers declarative models with DeclarativeBase/Mapped/mapped_column, engine and session lifecycle, CRUD with select() and Session.scalars(), relationships and eager loading (selectinload vs joinedload), transactions, async engines, and Alembic migrations. Use when defining database models in Python, querying relational databases (PostgreSQL, SQLite, MySQL) from application code, wiring a database into FastAPI, fixing N+1 or DetachedIns...databasespythongoVotes: 0GitHub stars: 8
Render PostgresASets up and optimizes Managed PostgreSQL on Render—connection strings (internal vs external), creation constraints, storage autoscaling, connection limits, high availability, read replicas, backups, and MCP inspection. Use when the user mentions Postgres, PostgreSQL, Render database, connection string, DATABASE_URL, backups, snapshots, replicas, HA, disk storage, connection pooling, or troubleshooting DB connectivity.databasesgosqlVotes: 0GitHub stars: 8
Render DisksAAttaches and manages persistent disks on Render services—mount paths, sizing, snapshots, file transfers, and single-instance constraints. Use when the user needs persistent storage, file uploads, a custom database on disk, CMS media storage, or needs to understand why their service can't scale horizontally or use zero-downtime deploys. Trigger terms: persistent disk, disk, storage, mount path, sizeGB, SSD, file uploads, snapshots, disk restore, ephemeral filesystem.databasespythonrustVotes: 0GitHub stars: 8
Render Background WorkersASets up and configures background workers on Render for queue-based job processing. Use when the user needs to process async jobs, consume from a queue, run Celery/Sidekiq/BullMQ/Asynq/Oban workers, handle graceful shutdown with SIGTERM, wire a worker to Key Value (Redis), or choose between workers and cron jobs for background work. Trigger terms: background worker, async jobs, queue consumer, Celery, Sidekiq, BullMQ, Asynq, Oban, job processing, SIGTERM, graceful shutdown.databasespythongoVotes: 0GitHub stars: 8
Query AlphafoldAQuery AlphaFold protein structure predictions. Use when user asks about protein structure, 3D structure, protein folding, or structure prediction. Triggers on "alphafold", "protein structure", "3D structure", "folding", "pLDDT", "structure prediction".databasespythonapiVotes: 0GitHub stars: 8
Prisma Driver Adapter ImplementationARequired reference for Prisma ORM 7 SQL driver adapter work. Use when implementing or modifying adapters, adding database drivers, or touching SqlDriverAdapter, Transaction, savepoint, result mapping, or DriverAdapterError behavior. Covers current transaction lifecycle, optional savepoint hooks, original database-error preservation, and verification.databasestypescriptsqlVotes: 0GitHub stars: 8
Prisma CliAPrisma ORM CLI commands reference covering init, generate, migrate, db, dev, complete, studio, validate, format, debug, and mcp. Use for ORM/database CLI workflows, not the Prisma Platform CLI. Triggers on "prisma init", "prisma generate", "prisma migrate", "prisma db", "prisma complete", "prisma studio", "prisma mcp".databasestypescriptgoVotes: 0GitHub stars: 8
Neo4j Query Tuning SkillADiagnoses and fixes slow Neo4j Cypher queries by reading execution plans, identifyingdatabasesgobashVotes: 0GitHub stars: 8
Neo4j Modeling SkillADesign, review, and refactor Neo4j graph data models. Use when choosing nodedatabasesgobashVotes: 0GitHub stars: 8
Neo4j Driver Python SkillANeo4j Python Driver v6 — driver lifecycle, execute_query, managed and explicitdatabasespythonrustVotes: 0GitHub stars: 8
Neo4j Driver Javascript SkillANeo4j JavaScript/TypeScript Driver v6 — driver lifecycle, executeQuery,databasesjavascripttypescriptVotes: 0GitHub stars: 8
Neo4j Driver Java SkillANeo4j Java Driver v6 — driver lifecycle, Maven/Gradle setup, executableQuery,databasesjavakotlinVotes: 0GitHub stars: 8
Neo4j Driver Go SkillACovers the Neo4j Go Driver v6 — driver lifecycle, ExecuteQuery, managed anddatabasesgobashVotes: 0GitHub stars: 8
Neo4j Driver Dotnet SkillANeo4j .NET Driver v6 — IDriver lifecycle, DI registration (singleton), ExecutableQuerydatabasesc#bashVotes: 0GitHub stars: 8
Database ObservabilityASet up Grafana Cloud Database Observability for MySQL and PostgreSQL — enables `pg_stat_statements` / Performance Schema, creates a least-privilege monitoring user, configures the `database_observability.postgres` / `database_observability.mysql` Alloy components, ships query samples + visual explain plans + RED metrics + schema details to Grafana Cloud, and correlates slow queries with application traces via `db.statement` / `db.system` OTel attributes. Use when monitoring database performan...databasessqlazureVotes: 0GitHub stars: 8
Airtable FiltersAUse this skill when the user wants to find, filter, or narrow down Airtable records by field values, even when they don't explicitly say "filter."databasesgoVotes: 0GitHub stars: 8
Successive Groupby AggregatesABuild hierarchical features for transaction panels by aggregating twice — first groupby (entity, sub-key) to get a per-(entity, sub-key) summary, then groupby (entity) on those summaries to compute mean/min/max/std across the sub-keys, capturing the *distribution* of per-customer behavior rather than a single flat meandatabasespythongoVotes: 0GitHub stars: 61
Next Click Time DeltaAComputes seconds until the next event within a group using diff().shift(-1) on sorted timestamps, capturing user behavior velocity.databasespythontestingVotes: 0GitHub stars: 61
Whoosh Fulltext Search IndexABuilds a Whoosh full-text search index over documents and queries it with boolean operators, field scoping, and proximity matching.databasespythonexpressVotes: 0GitHub stars: 61
Async Python PatternsAUse when writing asyncio Python code — async/await coroutines, concurrent I/O with asyncio.gather, task creation and cancellation, semaphore rate limiting, producer-consumer queues, async context managers, async generators, WebSocket servers, aiohttp web scraping, async database operations, run_in_executor for blocking calls, or testing async code with pytest-asyncio. Covers FastAPI and aiohttp patterns, synchronization primitives, timeout handling, and common pitfalls like event loop blockin...databasespythongoVotes: 0GitHub stars: 67
Enterprise Hibernate HbmADasel v3 query patterns for Hibernate .hbm.xml mapping files — entity-table binding, Java property-to-column extraction, one-to-many set/list/bag relationship tracing, many-to-one foreign key discovery, batch scanning across 60+ HBM files. Use when querying Hibernate ORM class mappings, extracting schema metadata from Java persistence layer, or auditing entity-column relationships in enterprise legacy codebases.databasesjavabashVotes: 0GitHub stars: 67
Local Runtime HarnessAMake a project reproducible and inspectable locally for coding agents. Use when a repo needs dev server scripts, .env.example, Docker Compose, seed/reset commands, health checks, local logs, or runtime debugging instructions.databasesdockerdebuggingVotes: 0GitHub stars: 3
001 Sql DatabasesASQL query optimization, schema design, indexing strategies, and relational database mastery for production data systemsdatabasespythongoVotes: 0GitHub stars: 7
001 Nosql DatabasesAMongoDB, Redis, Cassandra, DynamoDB, and distributed database patterns for scalable applicationsdatabasespythongoVotes: 0GitHub stars: 7