Database Fundamentals
DanielPodolsky/ownyourcode
Reviews schema design, SQL queries, ORM patterns. An agent skill from DanielPodolsky/ownyourcode.
Query and change the LLM Gateway Postgres schema with Drizzle — reads, raw SQL, analytics and usage queries, the log table versus the hourly aggregation tables, usedmodel ids, cost sums, cached…
$ npx skills add theopenco/llmgateway --skill database -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install theopenco/llmgateway database --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/theopenco/llmgateway.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/database .claude/skills/database && rm -rf skills-srcUse ~/.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/
Install the "database" agent skill from https://github.com/theopenco/llmgateway/tree/main/.agents/skills/database into .claude/skills/database/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database", 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 install https://github.com/theopenco/llmgateway/tree/main/.agents/skills/databaseType 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.
$ npx skills add theopenco/llmgateway --skill database -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install theopenco/llmgateway database --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/theopenco/llmgateway.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.agents/skills/database .agents/skills/database && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "database" agent skill from https://github.com/theopenco/llmgateway/tree/main/.agents/skills/database into .agents/skills/database/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database", 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.
$ npx skills add theopenco/llmgateway --skill database -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install theopenco/llmgateway database --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/theopenco/llmgateway.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.agents/skills/database .cursor/skills/database && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "database" agent skill from https://github.com/theopenco/llmgateway/tree/main/.agents/skills/database into .cursor/skills/database/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database", 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 https://github.com/theopenco/llmgateway.git --path .agents/skills/database--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add theopenco/llmgateway --skill database -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install theopenco/llmgateway database --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/theopenco/llmgateway.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.agents/skills/database .gemini/skills/database && rm -rf skills-srcUse ~/.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/
Install the "database" agent skill from https://github.com/theopenco/llmgateway/tree/main/.agents/skills/database into .gemini/skills/database/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database", 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.
$ gh skill install theopenco/llmgateway databaseInstalls 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).
$ npx skills add theopenco/llmgateway --skill database -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/theopenco/llmgateway.git skills-src && mkdir -p .github/skills && cp -r skills-src/.agents/skills/database .github/skills/database && rm -rf skills-srcUse ~/.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/
Install the "database" agent skill from https://github.com/theopenco/llmgateway/tree/main/.agents/skills/database into .github/skills/database/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database", 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.
$ npx skills add theopenco/llmgateway --skill database -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install theopenco/llmgateway database --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/theopenco/llmgateway.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.agents/skills/database .opencode/skills/database && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "database" agent skill from https://github.com/theopenco/llmgateway/tree/main/.agents/skills/database into .opencode/skills/database/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database", 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.
databaseQuery and change the LLM Gateway Postgres schema with Drizzle — reads, raw SQL, analytics and usage queries, the log table versus the hourly aggregation tables, usedmodel ids, cost sums, cached…
Database is an agent skill from theopenco/llmgateway. Query and change the LLM Gateway Postgres schema with Drizzle — reads, raw SQL, analytics and usage queries, the log table versus the hourly aggregation tables, usedmodel ids, cost sums, cached queries, and new columns. Use when editing packages/db/src/schema.ts, writing Drizzle or raw SQL, building dashboards, stats, or usage reports, adding an organization column, or pushing and seeding the local database. For migration files use the migrations skill.
Its SKILL.md is about 970 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.
It sits in Databases, covering ORMs and data access, Model routing and gateways and SQL. It works with SQL, PostgreSQL and pnpm. The repository describes itself as: Route, manage, and analyze your LLM requests across multiple providers with a unified API interface.
Read from SKILL.md and the folder at commit 4fd76f3. It shows what the files ask for, not the result of running them.
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.
Shell commands in SKILL.md call:
pnpmFrom the folder's file list and the shell code blocks in SKILL.md.
No URLs in SKILL.md. Its commands use pnpm, which can reach the network depending on how they are called.
From URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Database loads about 973 tokens when it runs. Until then it costs about 117 tokens; SKILL.md has 456 words of instructions outside code blocks.
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.
The automated check found no risky patterns in SKILL.md.
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.
Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 456 words (~973 tokens).
“Run commands from the repository root.”
Just SKILL.md in .agents/skills/database of theopenco/llmgateway.
Open the folder on GitHubat commit 4fd76f3
Database 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.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Database this skilltheopenco/llmgateway | 1.7k | — | ~973 | Automated safety check: Pass | Custom licence | |
| Database FundamentalsDanielPodolsky/ownyourcode | 290 | 1 repos | ~1.6k | Automated safety check: Pass | MIT | |
| Archestra Dev Migrationsarchestra-ai/archestra | 4.3k | — | ~804 | Automated safety check: Pass | Custom licence | |
| Drizzle DatabaseChatbotXIO/ChatbotX | 878 | — | ~2.1k | Automated safety check: Pass | Custom licence | |
| Drizzle Ormgrowupanand/ConvoForm | 101 | 1 repos | ~2.7k | Automated safety check: Pass | Apache-2.0 | |
| Discover Databaserand/cc-polymath | 181 | — | ~2k | Automated safety check: Pass | MIT |
DanielPodolsky/ownyourcode
Reviews schema design, SQL queries, ORM patterns. An agent skill from DanielPodolsky/ownyourcode.
archestra-ai/archestra
A skill your agent uses when changing Drizzle schemas, generating migrations, editing migration SQL, creating data-only migrations, diagnosing drizzle-kit check failures, or resolving…
ChatbotXIO/ChatbotX
Work with Drizzle ORM database schema, migrations, relations, and queries in PostgreSQL.
growupanand/ConvoForm
Type-safe SQL ORM for TypeScript with zero runtime overhead. An agent skill from growupanand/ConvoForm.
rand/cc-polymath
Automatically discover database skills when working with SQL, PostgreSQL, MongoDB, Redis, database schema design, query optimization, migrations, connection pooling, ORMs, or database selection.
312362115/claude
数据库代码审查 + Migration 安全检查. An agent skill from 312362115/claude.
theopenco/llmgateway
Write and validate an LLM Gateway marketing blog post in the repository's current house style, including structured frontmatter and a gpt-image-2 OpenGraph image.
theopenco/llmgateway
Run and report repository model or provider-mapping benchmarks.
theopenco/llmgateway
Create, update, and audit repository-local agent skills against the current LLM Gateway codebase.
theopenco/llmgateway
Security best practices, vulnerability review, and full security audits for LLM Gateway.
theopenco/llmgateway
Add a model or provider mapping to the catalogue, or verify one that was already written — pricing, capability and reasoning metadata, scoped e2e, and playground options for image/video models.
theopenco/llmgateway
Write a new LLM Gateway changelog entry. An agent skill from theopenco/llmgateway.
Works with
Categories
Query and change the LLM Gateway Postgres schema with Drizzle — reads, raw SQL, analytics and usage queries, the log table versus the hourly aggregation tables, usedmodel ids, cost sums, cached…. Database is an agent skill from theopenco/llmgateway. Query and change the LLM Gateway Postgres schema with Drizzle — reads, raw SQL, analytics and usage queries, the log table versus the hourly aggregation tables, usedmodel ids, cost sums, cached queries, and new columns.
Database fits situations like: editing packages/db/src/schema.ts; writing Drizzle; building dashboards; adding an organization column.
Run `npx skills add theopenco/llmgateway --skill database -a claude-code`. Or copy the skill folder (.agents/skills/database in theopenco/llmgateway) into .claude/skills/database in your project. Claude Code loads it when a task matches its description.
Run `npx skills add theopenco/llmgateway --skill database -a codex`. Or copy the skill folder (.agents/skills/database in theopenco/llmgateway) into .agents/skills/database in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add theopenco/llmgateway --skill database -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/database, .gemini/skills/database, .github/skills/database and .opencode/skills/database in your project.
Going by SKILL.md and its folder, Database needs the command-line tools its instructions call (pnpm).
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.
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
Database has a licence file (the repository's licence) that doesn't match a standard licence. Read it on GitHub before reusing the skill.
About 973 tokens (SKILL.md is roughly 3.9k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
Skills that share tags, products or a category with Database: Database Fundamentals (DanielPodolsky/ownyourcode, 290 stars), Archestra Dev Migrations (archestra-ai/archestra, 4.3k stars), Drizzle Database (ChatbotXIO/ChatbotX, 878 stars) and Drizzle Orm (growupanand/ConvoForm, 101 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
theopenco (a GitHub organization) maintains it in theopenco/llmgateway, which has 1,674 GitHub stars. The repository holds 19 skills in this directory. The repository was last updated on October 7, 2026.
Source: theopenco/llmgateway on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.