Databases

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

skills in category: 4,314
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 265–288 of 4,314 skills

Find CCSPlayerController AddedToEntityDatabaseAAgent fallback for CCSPlayerController_AddedToEntityDatabase (auto-generated, category: vfunc). Locate CCSPlayerController::AddedToEntityDatabase in the CS2 server module via IDA Pro MCP and emit a fresh, minimal-unique artifact. The deterministic preprocessor could not resolve this symbol on the current gamever - your job is the re-sign. Trigger: CCSPlayerController_AddedToEntityDatabase, CCSPlayerController::AddedToEntityDatabasedatabasesgodatabaseVotes: 0GitHub stars: 3
Opencode BridgeABridge between Openrind Desktop UI and OpenCode runtimedatabasesrustgoVotes: 0GitHub stars: 3
Openrind NavigateAQuery PostgreSQL with pg and navigate Openrind Shell's primary FUSE or compatibility workspace; /db is custom-agent-only.databasesshellbashVotes: 0GitHub stars: 3
Openrind DevADevelop Openrind Shell's OpenShell-supervised PostgreSQL FUSE runtime, compatibility sync runtime, and just-bash library.databasestypescriptrustVotes: 0GitHub stars: 3
Pulse DevelopmentAHandles Laravel Pulse setup, configuration, and custom card development. Activates when installing Pulse; configuring the dashboard or authorization gate; setting up recorders and filtering; building custom Livewire cards; optimizing with Redis ingest or sampling; or when the user mentions /pulse, pulse:check, pulse:work, Pulse::record(), or application monitoring.databasesgophpVotes: 0GitHub stars: 7,117
Db Aspect ExtractionAExtracts a repository's database schema (tables, columns, foreign keys, indexes) into a DatabaseSchemaPayload for /adopt --db. Use when adopting the database.schema aspect. Reads Drizzle, Prisma, TypeORM, SQLAlchemy, raw SQL migrations, or a committed pg_dump — never a live database.databasesgosqlVotes: 0GitHub stars: 3
Drizzle OrmAUse Drizzle ORM for TypeScript schemas, queries, migrations, relations, and transactions.databasestypescriptgoVotes: 0GitHub stars: 4
ReleasesARead, synthesize, diagnose, clean, author, and publish the releases.db planning ledger (or legacy RELEASES.md where retained) through one routed workflow. Use for /releases; release status or health checks; stale-plan review against merged PRs, commits, and CHANGELOG entries; disciplined release creation or updates; ledger cleanup; historical anchors or backfill; publishing a planned GitHub Release; or deciding whether Radar or Finish Line is the better follow-up. Default invocation is read-o...databasesrustgoVotes: 0GitHub stars: 5
Better OptionsAPressure-test an option set before the operator picks. Catches an AI agent — this one included — conflating two separate problems into one menu, or quietly narrowing the field to a false dilemma that skips the boring option. Borrows debug-mantra's falsify-the-hypothesis rigor (disprove each option before trusting it) then ponytail's minimalism bias (of what survives, favor the smallest) to surface the option nobody named because it wasn't impressive enough. Trigger when an agent — this one i...databasesrustgoVotes: 0GitHub stars: 5
Writing PlansAUse when creating an implementation plan for a non-trivial task — any change spanning multiple files, involving a database migration, requiring specific sequencing, or being handed off to a subagent for execution.databasesgosqlVotes: 0GitHub stars: 189
System DesignAUse when designing a new service from scratch, writing a tech spec or RFC, selecting a database or communication pattern, estimating capacity, or reviewing a design for scalability and reliability gaps.databasespythongoVotes: 0GitHub stars: 189
SqlalchemyAUse when using async SQLAlchemy 2.0 — defining models, writing queries, managing async sessions, loading relationships without N+1, or setting up and debugging Alembic migrations.databasespythongoVotes: 0GitHub stars: 189
PydanticAUse when defining request/response schemas, writing custom validators, controlling serialization for PATCH endpoints, validating non-model data with TypeAdapter, or configuring app settings from environment variables with pydantic-settings.databasespythongoVotes: 0GitHub stars: 189
PostgresqlAUse when writing complex PostgreSQL queries, diagnosing slow queries with EXPLAIN ANALYZE, designing indexes (B-tree, GIN, partial, composite), handling concurrent writes and lock contention, or running safe live ALTER TABLE on large tables. For schema design, normalization, or relationship modelling, use database-design.databasesgosqlVotes: 0GitHub stars: 189
MongodbAUse when writing async MongoDB queries with Motor, designing aggregation pipelines, creating indexes, running multi-document transactions, or working with adk.state in Agentex agents.databasestypescriptpythonVotes: 0GitHub stars: 189
Database DesignAUse when designing a relational schema — normalization (1NF–3NF), primary key strategy, modelling relationships, naming conventions, or planning a zero-downtime migration with the expand-contract pattern. For writing and tuning queries, indexes, or EXPLAIN ANALYZE, use postgresql.databasestypescriptpythonVotes: 0GitHub stars: 189
Data PipelinesAUse when building or debugging data pipelines with Airflow or Prefect, writing dbt models or tests, designing incremental loads, implementing idempotent ETL/ELT jobs, validating data quality, or orchestrating multi-step data workflows.databasespythongoVotes: 0GitHub stars: 189
Rust DatabaseAUse when building or reviewing production Rust database code (sqlx, diesel, tokio-postgres, rusqlite, deadpool, bb8) for database pool exhaustion, transaction rollback, transaction cancellation safety, a serialization failure or deadlock retry, database migration ordering in a rolling deploy, a schema integration test, or a sqlx 0.9 upgrade that hits SqlSafeStr or AssertSqlSafe.databasesrustgoVotes: 0GitHub stars: 2
Git Local HazardsALocal git traps where a green command is wrong. Use when branching after a squash-merge, cutting a PR branch, after a clean merge or rebase, when a staged file vanishes, or before reset --hard.databasesrustgoVotes: 0GitHub stars: 58
Regelrecht DossierAFront-door router voor het werken aan een regelrecht-dossier. Gebruik dit aan het begin van een dossier, of bij twijfel over waar te beginnen — het triageert de situatie en routeert naar de juiste skill (regelrecht-stelselanalyse voor desk-review/corpus-completion, regelrecht-audit-products voor live expert-validatie) en de juiste volgorde. Bevat het routeringsprincipe: feitelijke defecten routeren naar de desk, oordeels-/praktijkvragen naar de workshop. Dossier-agnostisch.databasesgoVotes: 0GitHub stars: 23
Zero Downtime Database MigrationAUse when changing schema on a live production database without dropping traffic, doing expand/contract migrations, backfilling new columns on million-plus-row tables, dual-writing across schemas, renaming a hot column, splitting a table, or adding a foreign key to a big table. Triggers: ALTER TABLE locks the world, "must be removed in a separate deploy", expand-contract-cleanup phases, NOT NULL on populated column, foreign-key add on big table, dropping a column still read by old replicas, lo...databasesgorubyVotes: 0GitHub stars: 2
Supabase AdminASupabase administration, RLS policies, migrations, and schema design. Use for database architecture, Row Level Security, performance tuning, auth integration. Activate on "Supabase", "RLS", "migration", "policy", "schema", "auth.uid()". NOT for Supabase Auth UI configuration (use dashboard), edge functions (use cloudflare-worker-dev), or general SQL without Supabase context.databasesjavascriptgoVotes: 0GitHub stars: 2
Sqlite Durable Agent StateADesign durable local SQLite state for multi-agent developer tooling that survives package upgrades, concurrent writers, and crashes: canonical env-pinned paths, WAL/busy_timeout discipline, idempotent verified migrations, and safe writer topology. Use when a daemon, CLI, or agent fleet needs a persistent local DB, when reviewing a schema/path change before it ships, or when diagnosing an already-fragmented multi-.db mess. NOT for relational schema/query design (use daemon-development for the ...databasesrustgoVotes: 0GitHub stars: 2
Postgres Connection PoolingAChoosing a Postgres connection pool mode that matches your workload — pgBouncer session/transaction/statement modes, the prepared-statement story (pgBouncer 1.21+), Supabase Supavisor's port-per-mode pattern (5432 vs 6543), AWS RDS Proxy pinning triggers, and `pg_stat_activity` diagnostics. Grounded in pgbouncer.org, supabase.com, AWS docs, and PostgreSQL docs. NOT for ORM-specific connection config, Postgres replication/read-replica design, non-Postgres poolers (PgPool for MySQL, ProxySQL), ...databasespythongoVotes: 0GitHub stars: 2