Agent skill

DB Context

by SilvioBaratto in SilvioBaratto/optimizer

Complete knowledge of the optimizer PostgreSQL database: 57 ingestion tables, schema, relationships, live row counts, query patterns, and conventions.

Custom licenceAuto-check: notesDatabases

Install DB Context

skills CLI

$ npx skills add SilvioBaratto/optimizer --skill db-context -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI

$ gh skill install SilvioBaratto/optimizer db-context --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy

$ git clone --depth 1 https://github.com/SilvioBaratto/optimizer.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/db-context .claude/skills/db-context && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Paste into Claude Code

Install the "db-context" agent skill from https://github.com/SilvioBaratto/optimizer/tree/development/.claude/skills/db-context into .claude/skills/db-context/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "db-context", then confirm the skill loads.

Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

$skill-installer

$skill-installer install https://github.com/SilvioBaratto/optimizer/tree/development/.claude/skills/db-context

Type this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.

skills CLI

$ npx skills add SilvioBaratto/optimizer --skill db-context -a codex

Project install goes to .agents/skills/; add -g for ~/.codex/skills/.

GitHub CLI

$ gh skill install SilvioBaratto/optimizer db-context --agent codex

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/SilvioBaratto/optimizer.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.claude/skills/db-context .agents/skills/db-context && rm -rf skills-src

Use ~/.agents/skills/ instead of .agents/skills for a personal install.

Codex skills documentation · loads skills from .agents/skills/

Paste into Codex

Install the "db-context" agent skill from https://github.com/SilvioBaratto/optimizer/tree/development/.claude/skills/db-context into .agents/skills/db-context/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "db-context", then confirm the skill loads.

Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add SilvioBaratto/optimizer --skill db-context -a cursor

Project install goes to .agents/skills/; add -g for ~/.cursor/skills/.

GitHub CLI

$ gh skill install SilvioBaratto/optimizer db-context --agent cursor

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/SilvioBaratto/optimizer.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.claude/skills/db-context .cursor/skills/db-context && rm -rf skills-src

Use ~/.cursor/skills/ instead of .cursor/skills for a personal install.

Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/

Paste into Cursor

Install the "db-context" agent skill from https://github.com/SilvioBaratto/optimizer/tree/development/.claude/skills/db-context into .cursor/skills/db-context/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "db-context", then confirm the skill loads.

Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

gemini skills install

$ gemini skills install https://github.com/SilvioBaratto/optimizer.git --path .claude/skills/db-context

--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.

skills CLI

$ npx skills add SilvioBaratto/optimizer --skill db-context -a gemini-cli

Project install goes to .agents/skills/; add -g for ~/.gemini/skills/.

GitHub CLI

$ gh skill install SilvioBaratto/optimizer db-context --agent gemini-cli

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/SilvioBaratto/optimizer.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.claude/skills/db-context .gemini/skills/db-context && rm -rf skills-src

Use ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.

Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/

Paste into Gemini CLI

Install the "db-context" agent skill from https://github.com/SilvioBaratto/optimizer/tree/development/.claude/skills/db-context into .gemini/skills/db-context/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "db-context", then confirm the skill loads.

Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

GitHub CLI

$ gh skill install SilvioBaratto/optimizer db-context

Installs for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).

skills CLI

$ npx skills add SilvioBaratto/optimizer --skill db-context -a github-copilot

Project install goes to .agents/skills/; add -g for ~/.copilot/skills/.

Manual copy

$ git clone --depth 1 https://github.com/SilvioBaratto/optimizer.git skills-src && mkdir -p .github/skills && cp -r skills-src/.claude/skills/db-context .github/skills/db-context && rm -rf skills-src

Use ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.

GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/

Paste into GitHub Copilot

Install the "db-context" agent skill from https://github.com/SilvioBaratto/optimizer/tree/development/.claude/skills/db-context into .github/skills/db-context/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "db-context", then confirm the skill loads.

GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

skills CLI

$ npx skills add SilvioBaratto/optimizer --skill db-context -a opencode

OpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.

GitHub CLI

$ gh skill install SilvioBaratto/optimizer db-context --agent opencode

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/SilvioBaratto/optimizer.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.claude/skills/db-context .opencode/skills/db-context && rm -rf skills-src

Use ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.

OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/

Paste into OpenCode

Install the "db-context" agent skill from https://github.com/SilvioBaratto/optimizer/tree/development/.claude/skills/db-context into .opencode/skills/db-context/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "db-context", then confirm the skill loads.

OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.

Facts

Skill name: db-context
GitHub stars: 176
Token cost: ~6.4k tokens
SKILL.md length: 1,952 words
Files: 3 (incl. references)
Skills in repo: 10
Repo updated: Oct 7, 2026
First seen: Oct 7, 2026
Licence: Custom licence

At a glance

Complete knowledge of the optimizer PostgreSQL database: 57 ingestion tables, schema, relationships, live row counts, query patterns, and conventions.

Works in 9 steps: Table Catalog (53 documented + 2 infra) → Relationship Map → Base Model Pattern → …
Tasks that involve Database migrations
SKILL.md covers 1. Table Catalog (53…, 2. Relationship Map, 3. Base Model Pattern and 4. Design Patterns, plus 5 more sections
Needs FRED_API_KEY

What it does

DB Context is an agent skill from SilvioBaratto/optimizer. Complete knowledge of the optimizer PostgreSQL database: 57 ingestion tables, schema, relationships, live row counts, query patterns, and conventions. Load this skill proactively whenever working with database models (packages/portopt-db/src/portoptdb/models/), repositories (packages/portopt-db/src/portoptdb/repositories/ + ingestion/app/repositories/jobs/), Alembic migrations (packages/portopt-db/alembic/), SQL queries, or any code that reads from or writes to the database. Also load when discussing table…

Its SKILL.md is about 6.4k tokens, which your agent loads only when the skill is triggered. The skill folder holds 3 other files, including reference files (for example `references/data-inventory.md` and `references/full-schema.md`).

It sits in Databases, covering Database migrations, SQL and Database schema design. It works with PostgreSQL, SQL and yfinance. The repository describes itself as: Quantitative portfolio construction and optimization platform built on skfolio and scikit-learn.

When your agent uses it

Tasks that involve Database migrations
Tasks that involve SQL
Tasks that involve Database schema design

Example prompts

“/db-context”

Requirements

Docker
A credential in FRED_API_KEY

Workflow steps

9 steps, taken from the step headings in SKILL.md.

Table Catalog (53 documented + 2 infra)
Relationship Map
Base Model Pattern
Design Patterns
Connection & Configuration
Migration Conventions
Common Query Patterns
Adding a New Table
Gotchas

What it can do on your machine

Read from SKILL.md and the folder at commit 63e897b. It shows what the files ask for, not the result of running them.

Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md (its code samples are python and bash).
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names these keys or tokens, usually read from environment variables:
- FRED_API_KEY
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

DB Context loads about 6.4k tokens when it runs, and up to ~16k if it reads all its reference files. Until then it costs about 166 tokens; SKILL.md has 1,952 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it: ~166
When it runs · the whole SKILL.md, loaded when a task matches: ~6.4k
With references · SKILL.md plus every file in references/, read only if the agent opens them: ~16k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check: notes

The automated check noted patterns worth knowing about, such as sudo or a known installer.

NoteMentions a .env fileSKILL.md:300

Overridable via `.env` (`DATABASE_POOL_SIZE`, …); the running container may show larger values.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 1,952 words (~6,434 tokens).

“PostgreSQL 16 (Alpine) in Docker on host port 54320. Connection: postgresql://postgres:postgres@localhost:54320/optimizer_db”

— opening of SKILL.md by SilvioBaratto, Custom licence

name: db-context

Outline of SKILL.md

Optimizer Database Reference
1. Table Catalog (53 documented + 2 infra)
Core (2)
Per-ticker — Prices & Actions (4, FK → instruments.id CASCADE)
Per-ticker — Fundamentals (4, FK → instruments.id CASCADE)
Per-ticker — Estimates (7, FK → instruments.id CASCADE)
Per-ticker — Analyst (3, FK → instruments.id CASCADE)
Per-ticker — Ownership (7, FK → instruments.id CASCADE)
Per-ticker — News (1, FK → instruments.id CASCADE)
Calendars (4, market-wide, no FK)
ETF (8, FK → instruments.id CASCADE)
Sector & Market (4, market-wide, no FK)
Macro (9)
Operations (2)
Infrastructure (2, not in models)
2. Relationship Map
3. Base Model Pattern
4. Design Patterns
Upsert (ON CONFLICT)
Repositories (package split)
Engine (DbConfig-injected)
Child-table properties
EAV
Time-Series Deduplication
Survivorship Bias
5. Connection & Configuration
6. Migration Conventions
7. Common Query Patterns
8. Adding a New Table
9. Gotchas

Read the full SKILL.md on GitHub

Files

SKILL.md and 2 other files (references) in .claude/skills/db-context of SilvioBaratto/optimizer.

SKILL.md
references/data-inventory.md
references/full-schema.md

Open the folder on GitHubat commit 63e897b

Compare with similar skills

DB Context next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

DB Context compared with similar skills
Skill	Stars	Used in	Tokens	Auto-check	Licence	Repo updated
DB Context this skillSilvioBaratto/optimizer	176	—	~6.4k	Automated safety check: Notes	Custom licence	today
DatabasesMicrock/ordinary-claude-skills	403	—	~1.9k	Automated safety check: Notes	MIT	1 mo ago
Supabase Postgres Best Practicessupabase/agent-skills	2.7k	24 repos	~808	Automated safety check: Pass	MIT	5 days ago
Schema Explorationtimescale/pg-aiguide	1.9k	—	~1.1k	Automated safety check: Pass	Apache-2.0	today
Cursor BYOK Database Schemaleookun/cursor-byok	3.2k	—	~1.3k	Automated safety check: Pass	MIT	today
Database Migrations SQL Migrationsrmyndharis/antigravity-skills	1.7k	3 repos	~577	Automated safety check: Notes	MIT	7 days ago

Similar skills

Databases
Microck/ordinary-claude-skills
Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin).
403 GitHub stars~1.9k tokensUpdated 1 mo ago
DatabasesAuto-check: notes
Supabase Postgres Best Practices
supabase/agent-skills
Official
Gives the agent Postgres rules to consult before writing or changing tables, queries, indexes, RLS policies or migrations, and when diagnosing slow queries.
2.7k GitHub starsUsed in 24 repos~808 tokens
DatabasesAuto-check passed
Schema Exploration
timescale/pg-aiguide
Explore an existing PostgreSQL database before answering questions about its data or writing SQL.
1.9k GitHub stars~1.1k tokensUpdated today
DatabasesAuto-check passed
Cursor BYOK Database Schema
leookun/cursor-byok
Guides SQLite schema changes in the Cursor BYOK server, keeping SQLx migrations, the Rust store, API contracts and fixtures aligned.
3.2k GitHub stars~1.3k tokensUpdated today
DatabasesAuto-check passed
Database Migrations SQL Migrations
rmyndharis/antigravity-skills
SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server
1.7k GitHub starsUsed in 3 repos~577 tokens
DatabasesAuto-check: notes
Diesel Guard
ayarotsky/diesel-guard
Lints Diesel and SQLx Postgres migrations for unsafe schema changes that lock tables or cause downtime, and authors custom Rhai checks.
121 GitHub stars~3.1k tokensUpdated 9 days ago
DatabasesAuto-check passed

Questions about DB Context

What does DB Context do?

Complete knowledge of the optimizer PostgreSQL database: 57 ingestion tables, schema, relationships, live row counts, query patterns, and conventions. DB Context is an agent skill from SilvioBaratto/optimizer. Complete knowledge of the optimizer PostgreSQL database: 57 ingestion tables, schema, relationships, live row counts, query patterns, and conventions.

When should I use DB Context?

DB Context fits situations like: tasks that involve Database migrations; tasks that involve SQL; tasks that involve Database schema design.

How do I install DB Context in Claude Code?

Run `npx skills add SilvioBaratto/optimizer --skill db-context -a claude-code`. Or copy the skill folder (.claude/skills/db-context in SilvioBaratto/optimizer) into .claude/skills/db-context in your project. Claude Code loads it when a task matches its description.

How do I install DB Context in Codex?

Run `npx skills add SilvioBaratto/optimizer --skill db-context -a codex`. Or copy the skill folder (.claude/skills/db-context in SilvioBaratto/optimizer) into .agents/skills/db-context in your project. Codex loads it when a task matches its description.

Can I use DB Context in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add SilvioBaratto/optimizer --skill db-context -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/db-context, .gemini/skills/db-context, .github/skills/db-context and .opencode/skills/db-context in your project.

What does DB Context need to run?

Going by SKILL.md and its folder, DB Context needs credentials named FRED_API_KEY. Our summary lists: Docker; A credential in FRED_API_KEY.

Does DB Context access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is DB Context safe to install?

Our automated static check of SKILL.md found notes only (mentions a .env file), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.

What licence does DB Context use?

DB Context has a licence file (the repository's licence) that doesn't match a standard licence. Read it on GitHub before reusing the skill.

How many tokens does DB Context use?

About 6.4k tokens (SKILL.md is roughly 26k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 9.8k tokens, read only when the agent opens those files.

What are the alternatives to DB Context?

Skills that share tags, products or a category with DB Context: Databases (Microck/ordinary-claude-skills, 403 stars), Supabase Postgres Best Practices (supabase/agent-skills, 2.7k stars), Schema Exploration (timescale/pg-aiguide, 1.9k stars) and Cursor BYOK Database Schema (leookun/cursor-byok, 3.2k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains DB Context?

SilvioBaratto (a GitHub user) maintains it in SilvioBaratto/optimizer, which has 176 GitHub stars. The repository holds 10 skills in this directory. The repository was last updated on October 7, 2026.

Source: SilvioBaratto/optimizer on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.

DB Context

Install DB Context

Facts

At a glance

What it does

When your agent uses it

Example prompts

Requirements

Workflow steps

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Context cost

Safety

SKILL.md

Files

Compare with similar skills

Similar skills

Databases

Supabase Postgres Best Practices

Schema Exploration

Cursor BYOK Database Schema

Database Migrations SQL Migrations

Diesel Guard

More from SilvioBaratto/optimizer

Yfinance

Fund Orchestration

Optimization Objective Map

Macro Regime Read

Rebalancing Execution

Risk Limits Check

Questions about DB Context

Install DB Context

Facts

At a glance

What it does

When your agent uses it

Example prompts

Requirements

Workflow steps

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Context cost

Safety

SKILL.md

Files

Compare with similar skills

Similar skills

More from SilvioBaratto/optimizer

Related

Questions about DB Context