Databases

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

skills in category: 4,700
pages available: 196

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 2,113–2,136 of 4,700 skills

Schema UpdateAUse any time you are about to add, change, or migrate a Postgres or Doltgres table — editing schema TS, running `pnpm db:generate:*`, writing a migration `.sql`, touching `meta/_journal.json` / `*_snapshot.json`, or debugging a migration that didn't apply on candidate-a. Mandatory before any schema edit.databasesgobashVotes: 0GitHub stars: 4
Rbac ExpertAAuthorization/RBAC navigation for cogni-template — points at the canon (OpenFGA model, AuthorizationPort, rbac.md invariants, the access-request flow, the hardening roadmap) and captures the durable mental model + hard-won gotchas that aren't obvious when you read it: OpenFGA is the sole authority, principal→role→capability, deny-by-default / fail-closed-with-distinction, why authorization is `undefined`, immutable hashed models, the request→approve→flight grant loop, and which checks aren't ...databasesrustgoVotes: 0GitHub stars: 4
Dolthub Local CloneBClone a Cogni knowledge repo from DoltHub and read it locally, WITHOUT the operator/node being live. Use to recover, audit, diff, or verify a node's knowledge hub straight from its DoltHub mirror (`cogni-dao/<slug>`) — operator down, confirming a `dolt_push` landed, bootstrapping a fork, offline archaeology. Triggers: "clone our dolthub", "read the knowledge repo locally", "recover the hub", "verify the push", "dolt clone fails with table has unknown fields", "doltgres clone".databasesgobashVotes: 0GitHub stars: 4
Database ExpertACogni database architecture and operations router — Postgres-vs-Doltgres placement, DB-per-node boundaries, shared-Postgres capacity/noisy-neighbor controls, metering and graduation, node-scoped access, schema ownership, migrations, backups, and runtime health. Use for schema changes, `DATABASE_URL`/`DOLTGRES_URL`, Drizzle, migration delivery, Postgres/Doltgres/Redis health, query pressure, connection limits, tenant isolation, database observability, or deciding when a node must leave shared ...databasesrustgoVotes: 0GitHub stars: 4
Data ResearchAStandard for building Cogni research views — dashboard slices, wallet/market analytics, trader comparisons, P/L curves, bet histograms, anything that aggregates over `poly_trader_fills`, `poly_trader_position_snapshots`, `poly_market_outcomes`, or any other large operational table. Use this skill any time you are about to write a new database query that supports a research, dashboard, comparison, or analytics view — whether the user calls it a "research view", "comparison panel", "P/L tab", "...databasesjavascripttypescriptVotes: 0GitHub stars: 4
UdesignAUse before any creative work — features, components, behavior changes. Turns an idea into a validated spec with explicit tradeoffs and unknowns, and splits scope into multiple tasks if it's too large. Output is the `## Context` and `## Design` sections of the task file.databasesgodatabaseVotes: 0GitHub stars: 47
Obelisk UrqlAWrite, review, debug, parse, or generate Obelisk urQL — the SQL dialect of the Obelisk RDBMS Gall agent. Covers clause ordering, object qualification, naming/literal rules, scripts/atomicity, DDL, DML, queries, joins, set operations, scalar functions, time travel, system views, and the Hoon API. Use whenever working with urQL scripts or the %obelisk agent.databasessqldebuggingVotes: 0GitHub stars: 37
Obelisk TestAWriting unit tests for obelisk using the test-helpers library. Covers test helper crud-txn, expected result construction, and failure testing patterns.databasesexpresstestingVotes: 0GitHub stars: 37
redis-jsAWork with the Upstash Redis JavaScript/TypeScript SDK for serverless Redis operations. Use for caching, session storage, rate limiting, leaderboards, full-text search (querying, filtering, aggregating with @upstash/redis search extension), and all Redis data structures. Supports automatic serialization/deserialization of JavaScript types. Search also available via @upstash/search-redis and @upstash/search-ioredis adapters for TCP clients.databasesjavascripttypescriptVotes: 0GitHub stars: 973
Galileo On Prem Luna Studio SetupARender, preflight, validate, observe, and prepare Galileo/CSE joint-session install, upgrade, rollback, and retirement handoffs for Galileo Luna Studio on Kubernetes with dedicated PostgreSQL, object storage, backend and UI, routing, four out-of-band Secrets, GPU Jobs, Vertex AI, and remote or hybrid training. Use when operating Luna Studio for Galileo On-Prem or when an exact umbrella package requires a reviewed Luna overlay instead of its standalone release.databasesbashsqlVotes: 0GitHub stars: 39
PostgresqlAUse when writing complex PostgreSQL queries, diagnosing slow queries with EXPLAIN ANALYZE, designing indexes, handling concurrent writes, or planning safe schema migrations on large tables.databasesgosqlVotes: 0GitHub stars: 21
DatabaseADatabase guidance for schema naming, safe migrations, indexing, N+1 detection, transaction scope, and soft-delete versus hard-delete tradeoffs. Use when designing schemas, writing migrations, or tuning persistence behavior.databasesgosqlVotes: 0GitHub stars: 21
Database DesignAUse when designing a schema, adding indexes to fix slow queries, writing a zero-downtime migration, diagnosing N+1 issues with EXPLAIN ANALYZE, or configuring connection pooling for a PostgreSQL-backed service.databasestypescriptpythonVotes: 0GitHub stars: 21
Ship A FeatureAThe end-to-end loop for adding any capability to Resume OS — schema, migration, data layer, MCP tool, server action, UI, README. Use whenever adding or substantially changing a feature, a data model, or anything a user can do. Triggers on "add", "build", "implement", "support", "let me be able to", "new tool", "new field", "new screen".databasesbashsqlVotes: 0GitHub stars: 4
Alembic Best PracticesAAlembic migration patterns for naming conventions, safety checks, expand-contract, env.py configuration, and CI integrationdatabasespythonrustVotes: 0GitHub stars: 43
Supabase Postgres Best PracticesAPostgreSQL performance optimization guidelines from Supabase. Apply when writing SQL, designing schemas, configuring RLS, or optimizing database performance.databasesrustgoVotes: 0GitHub stars: 43
Postgres Best PracticesAPostgreSQL best practices for database design, query optimization, and performance tuningdatabasesgosqlVotes: 0GitHub stars: 43
Django Best PracticesADjango patterns for production-ready Python web applicationsdatabasespythongoVotes: 0GitHub stars: 43
Score RfiAScore vendor RFI responses using a 0-3 rubric with SQLite storagedatabasesbashsqlVotes: 0GitHub stars: 52
MdfindASearch PDF, PPTX, and image content in Attachments using macOS SpotlightdatabasesbashVotes: 0GitHub stars: 52
Graph QueryAQuery the vault's knowledge graph index using natural language or structured queries.databasesbashnodeVotes: 0GitHub stars: 52
Csv To SqlAConvert CSV files to SQLite databases for efficient queryingdatabasesgobashVotes: 0GitHub stars: 52
Sql QueriesA跨主流数仓方言（Snowflake、BigQuery、Databricks、PostgreSQL 等）编写正确且高性能的 SQL。适用于编写查询、优化慢 SQL、跨方言转换，或构建包含 CTE、窗口函数和聚合的复杂分析查询。databasesgosqlVotes: 0GitHub stars: 2
Data ExplorationA数据集画像和探索，理解数据的结构、质量和分布模式。适用于接触新数据集、评估数据质量、发现列分布、识别空值和异常值，或决定分析维度。databasesgosqlVotes: 0GitHub stars: 2