Agent skill

Database

by theopenco in 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…

Custom licenceAuto-check passedDatabases

Install Database

skills CLI
$ npx skills add theopenco/llmgateway --skill database -a claude-code

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

GitHub CLI
$ gh skill install theopenco/llmgateway database --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/theopenco/llmgateway.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/database .claude/skills/database && 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/

Facts

Skill name
database
GitHub stars
1.7k
Token cost
~973 tokens
SKILL.md length
456 words
Files
1
Skills in repo
19
Repo updated
First seen
Licence
Custom licence

At a glance

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…

  • Editing packages/db/src/schema.ts
  • SKILL.md covers Schema changes, Queries and Cached client
  • Calls pnpm
  • Writing Drizzle

What it does

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.

When your agent uses it

  • Editing packages/db/src/schema.ts
  • Writing Drizzle
  • Building dashboards
  • Adding an organization column

Example prompts

  • “/database”

What it can do on your machine

Read from SKILL.md and the folder at commit 4fd76f3. 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

    Shell commands in SKILL.md call:

    • pnpm

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    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.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

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.

Always · name and description, kept in context so the agent knows when to use it
~117
When it runs · the whole SKILL.md, loaded when a task matches
~973

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 passed

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.

SKILL.md

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.”

— opening of SKILL.md by theopenco, Custom licence
name
database

Read the full SKILL.md on GitHub

Files

Just SKILL.md in .agents/skills/database of theopenco/llmgateway.

Open the folder on GitHubat commit 4fd76f3

Compare with similar skills

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.

Database compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Database this skilltheopenco/llmgateway1.7k—~973Automated safety check: PassCustom licence
Database FundamentalsDanielPodolsky/ownyourcode2901 repos~1.6kAutomated safety check: PassMIT
Archestra Dev Migrationsarchestra-ai/archestra4.3k—~804Automated safety check: PassCustom licence
Drizzle DatabaseChatbotXIO/ChatbotX878—~2.1kAutomated safety check: PassCustom licence
Drizzle Ormgrowupanand/ConvoForm1011 repos~2.7kAutomated safety check: PassApache-2.0
Discover Databaserand/cc-polymath181—~2kAutomated safety check: PassMIT

Similar skills

  • Database Fundamentals

    DanielPodolsky/ownyourcode

    Reviews schema design, SQL queries, ORM patterns. An agent skill from DanielPodolsky/ownyourcode.

    290 GitHub starsUsed in 1 repo~1.6k tokens
    DatabasesAuto-check passed
  • Archestra Dev Migrations

    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…

    4.3k GitHub stars~804 tokensUpdated today
    DatabasesAuto-check passed
  • Drizzle Database

    ChatbotXIO/ChatbotX

    Work with Drizzle ORM database schema, migrations, relations, and queries in PostgreSQL.

    878 GitHub stars~2.1k tokensUpdated today
    DatabasesAuto-check passed
  • Drizzle Orm

    growupanand/ConvoForm

    Type-safe SQL ORM for TypeScript with zero runtime overhead. An agent skill from growupanand/ConvoForm.

    101 GitHub starsUsed in 1 repo~2.7k tokens
    DatabasesAuto-check passed
  • Discover Database

    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.

    181 GitHub stars~2k tokensUpdated 7 mo ago
    DatabasesAuto-check passed
  • DB Review

    312362115/claude

    数据库代码审查 + Migration 安全检查. An agent skill from 312362115/claude.

    107 GitHub stars~1.8k tokensUpdated 4 mo ago
    DatabasesAuto-check passed

More from theopenco/llmgateway

All 19 skills in this repo
  • Blog

    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.

    1.7k GitHub stars~2.2k tokensUpdated today
    Auto-check passed
  • Model Benchmarks

    theopenco/llmgateway

    Run and report repository model or provider-mapping benchmarks.

    1.7k GitHub stars~1.1k tokensUpdated today
    Auto-check: notes
  • Skill Authoring

    theopenco/llmgateway

    Create, update, and audit repository-local agent skills against the current LLM Gateway codebase.

    1.7k GitHub stars~662 tokensUpdated today
    Auto-check passed
  • Security Audit

    theopenco/llmgateway

    Security best practices, vulnerability review, and full security audits for LLM Gateway.

    1.7k GitHub stars~1.8k tokensUpdated today
    Auto-check passed
  • Add Model

    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.

    1.7k GitHub stars~5k tokensUpdated today
    Auto-check: notes
  • Changelog

    theopenco/llmgateway

    Write a new LLM Gateway changelog entry. An agent skill from theopenco/llmgateway.

    1.7k GitHub stars~2k tokensUpdated today
    Auto-check passed

Categories

Questions about Database

What does Database do?

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.

When should I use Database?

Database fits situations like: editing packages/db/src/schema.ts; writing Drizzle; building dashboards; adding an organization column.

How do I install Database in Claude Code?

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.

How do I install Database in Codex?

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.

Can I use Database 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 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.

What does Database need to run?

Going by SKILL.md and its folder, Database needs the command-line tools its instructions call (pnpm).

Does Database 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 Database safe to install?

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.

What licence does Database use?

Database 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 Database use?

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.

What are the alternatives to Database?

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.

Who maintains Database?

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.