Agent skill

Production Awid DB

Connect to the awid.ai production database for migrations, audits, and data operations.

MITAuto-check: notes

Install Production Awid DB

skills CLI

$ npx skills add awebai/aweb --skill production-awid-db -a claude-code

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

GitHub CLI

$ gh skill install awebai/aweb production-awid-db --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/awebai/aweb.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/production-awid-db .claude/skills/production-awid-db && 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 "production-awid-db" agent skill from https://github.com/awebai/aweb/tree/main/.claude/skills/production-awid-db into .claude/skills/production-awid-db/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "production-awid-db", 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/awebai/aweb/tree/main/.claude/skills/production-awid-db

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 awebai/aweb --skill production-awid-db -a codex

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

GitHub CLI

$ gh skill install awebai/aweb production-awid-db --agent codex

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

Manual copy

$ git clone --depth 1 https://github.com/awebai/aweb.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.claude/skills/production-awid-db .agents/skills/production-awid-db && 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 "production-awid-db" agent skill from https://github.com/awebai/aweb/tree/main/.claude/skills/production-awid-db into .agents/skills/production-awid-db/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "production-awid-db", 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 awebai/aweb --skill production-awid-db -a cursor

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

GitHub CLI

$ gh skill install awebai/aweb production-awid-db --agent cursor

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

Manual copy

$ git clone --depth 1 https://github.com/awebai/aweb.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.claude/skills/production-awid-db .cursor/skills/production-awid-db && 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 "production-awid-db" agent skill from https://github.com/awebai/aweb/tree/main/.claude/skills/production-awid-db into .cursor/skills/production-awid-db/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "production-awid-db", 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/awebai/aweb.git --path .claude/skills/production-awid-db

--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 awebai/aweb --skill production-awid-db -a gemini-cli

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

GitHub CLI

$ gh skill install awebai/aweb production-awid-db --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/awebai/aweb.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.claude/skills/production-awid-db .gemini/skills/production-awid-db && 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 "production-awid-db" agent skill from https://github.com/awebai/aweb/tree/main/.claude/skills/production-awid-db into .gemini/skills/production-awid-db/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "production-awid-db", 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 awebai/aweb production-awid-db

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 awebai/aweb --skill production-awid-db -a github-copilot

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

Manual copy

$ git clone --depth 1 https://github.com/awebai/aweb.git skills-src && mkdir -p .github/skills && cp -r skills-src/.claude/skills/production-awid-db .github/skills/production-awid-db && 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 "production-awid-db" agent skill from https://github.com/awebai/aweb/tree/main/.claude/skills/production-awid-db into .github/skills/production-awid-db/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "production-awid-db", 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 awebai/aweb --skill production-awid-db -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 awebai/aweb production-awid-db --agent opencode

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

Manual copy

$ git clone --depth 1 https://github.com/awebai/aweb.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.claude/skills/production-awid-db .opencode/skills/production-awid-db && 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 "production-awid-db" agent skill from https://github.com/awebai/aweb/tree/main/.claude/skills/production-awid-db into .opencode/skills/production-awid-db/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "production-awid-db", 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: production-awid-db
GitHub stars: 115
Token cost: ~685 tokens
SKILL.md length: 169 words
Files: 1
Skills in repo: 17
Repo updated: Oct 10, 2026
First seen: Oct 7, 2026
Licence: MIT

At a glance

Connect to the awid.ai production database for migrations, audits, and data operations.

Works in 6 steps: Dump current data with --column-inserts → Transform the dump to match the new… → Drop the schema: DROP SCHEMA awid CASCADE; → …
SKILL.md covers Credentials, Connecting, Common operations and Schema reset (consolidation), plus 1 more section
Calls psql, uv and pg_dump

What it does

Production Awid DB is an agent skill from awebai/aweb. Connect to the awid.ai production database for migrations, audits, and data operations. Credentials at .env.awid-production.

Its SKILL.md is about 690 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

The repository describes itself as: Communication for AI agents: stable identity, durable mail and chat, and wake-up events across sessions, runtimes, machines, and organizations. MIT, self-hostable. The licence is MIT.

Example prompts

“/production-awid-db”

Requirements

Python 3

Workflow steps

6 steps, taken from the first numbered list in SKILL.md.

Dump current data with --column-inserts
Transform the dump to match the new schema (strip dropped columns)
Drop the schema: DROP SCHEMA awid CASCADE;
Run the migration (see above)
Load the transformed data
Verify counts and orphans

What it can do on your machine

Read from SKILL.md and the folder at commit 3fbb43c. 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:
- psql
- uv
- pg_dump
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md. Its commands use uv, 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

Production Awid DB loads about 685 tokens when it runs. Until then it costs about 36 tokens; SKILL.md has 169 words of instructions outside code blocks.

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

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:3

its, and data operations. Credentials at .env.awid-production.

NoteMentions a .env fileSKILL.md:12

/Users/juanre/prj/awebai/aweb/.env.awid-production

NoteMentions a .env fileSKILL.md:22

grep AWID_DATABASE_URL .env.awid-production

NoteMentions a .env fileSKILL.md:85

osted ac database configured from `../ac/.env.production` is SEPARATE.

NoteMentions a .env fileSKILL.md:90

- Do NOT use `source .env.awid-production` directly — the URL

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

The full file from awebai/aweb at commit 3fbb43c, republished under its MIT licence (© awebai). 169 words, ~685 tokens.

Download SKILL.mdSave it as .claude/skills/production-awid-db/SKILL.md (or your agent's skills folder).

name: production-awid-db
description: Connect to the awid.ai production database for migrations, audits, and data operations. Credentials at .env.awid-production.

awid.ai production database operations

Credentials

Production credentials are at the repo root:

/Users/juanre/prj/awebai/aweb/.env.awid-production

The key variable is AWID_DATABASE_URL — a Neon Postgres connection string. The schema name is awid (not aweb).

Connecting

bash

# Read the URL
grep AWID_DATABASE_URL .env.awid-production

# Connect with psql (strip the channel_binding parameter if psql complains)
psql 'postgresql://...'

Common operations

Audit table counts

sql

SELECT 'did_aw_mappings' as tbl, count(*) FROM awid.did_aw_mappings
UNION ALL SELECT 'did_aw_log', count(*) FROM awid.did_aw_log
UNION ALL SELECT 'dns_namespaces', count(*) FROM awid.dns_namespaces
UNION ALL SELECT 'public_addresses', count(*) FROM awid.public_addresses
UNION ALL SELECT 'teams', count(*) FROM awid.teams
UNION ALL SELECT 'team_certificates', count(*) FROM awid.team_certificates
ORDER BY tbl;

Check for orphan addresses (FK violation candidates)

sql

SELECT pa.name, ns.domain, pa.did_aw
FROM awid.public_addresses pa
JOIN awid.dns_namespaces ns ON ns.namespace_id = pa.namespace_id
LEFT JOIN awid.did_aw_mappings m ON m.did_aw = pa.did_aw
WHERE m.did_aw IS NULL;

Run migrations

bash

AWID_DATABASE_URL='...' AWID_DB_SCHEMA=awid uv run --project awid python - <<'PY'
import asyncio, os
from awid_service.db import AwidDatabaseInfra

async def main():
    infra = AwidDatabaseInfra(schema=os.environ.get('AWID_DB_SCHEMA', 'awid'))
    await infra.initialize(run_migrations=True)
    await infra.close()

asyncio.run(main())
PY

Dump data

bash

pg_dump 'postgresql://...' --schema=awid --data-only --column-inserts -f /tmp/awid-dump.sql

Schema reset (consolidation)

When consolidating migrations into a single 001_registry.sql:

Dump current data with --column-inserts
Transform the dump to match the new schema (strip dropped columns)
Drop the schema: DROP SCHEMA awid CASCADE;
Run the migration (see above)
Load the transformed data
Verify counts and orphans

This was done for awid 0.3.1. See commit cd01fac for the consolidation.

Notes

The hosted ac database configured from ../ac/.env.production is SEPARATE. It has an embedded awid copy with minimal data. The external awid.ai registry database is what matters for production.
Always verify orphan addresses before deploying migrations that add FK constraints.
Do NOT use source .env.awid-production directly — the URL contains & which breaks shell parsing. Use grep or inline the URL.

Files

Just SKILL.md in .claude/skills/production-awid-db of awebai/aweb.

Open the folder on GitHubat commit 3fbb43c

Compare with similar skills

Production Awid DB 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.

Production Awid DB compared with similar skills
Skill	Stars	Used in	Tokens	Auto-check	Licence	Repo updated
Production Awid DB this skillawebai/aweb	115	—	~685	Automated safety check: Notes	MIT	yesterday
Reversible MigrationJuliusBrussee/caveman	111k	1 repos	~196	Automated safety check: Pass	Apache-2.0	2 days ago
ConnectComposioHQ/awesome-claude-skills	77k	3 repos	~987	Automated safety check: Pass	None	23 days ago
Database Migrationsaffaan-m/ECC	277k	4 repos	~3k	Automated safety check: Pass	MIT	today
Database Migrationsaffaan-m/ECC	277k	1 repos	~2.4k	Automated safety check: Pass	MIT	today
Safe Database Migration Patternsaffaan-m/ECC	276k	—	~3.3k	Automated safety check: Pass	MIT	yesterday

Similar skills

Reversible Migration
JuliusBrussee/caveman
Implement reversible compatibility-safe transitions. Use for schema, data, API, protocol, configuration, or dependency migrations requiring rollback and…
111k GitHub starsUsed in 1 repo~196 tokens
DevelopmentAuto-check passed
Connect
ComposioHQ/awesome-claude-skills
Connect Claude to any app. An agent skill from ComposioHQ/awesome-claude-skills.
77k GitHub starsUsed in 3 repos~987 tokens
Productivity & AutomationAuto-check passed
Database Migrations
affaan-m/ECC
Safe, reversible database migration patterns: forward-only production changes, expand-contract zero-downtime renames, concurrent indexes, batched backfills, and per-tool workflows for PostgreSQL…
277k GitHub starsUsed in 4 repos~3k tokens
DatabasesAuto-check passed
Database Migrations
affaan-m/ECC
Şema değişiklikleri, veri migration'ları, rollback'ler ve PostgreSQL, MySQL ve yaygın ORM'ler (Prisma, Drizzle, Django, TypeORM, golang-migrate) arasında sıfır kesinti deployment'ları için…
277k GitHub starsUsed in 1 repo~2.4k tokens
DatabasesAuto-check passed
Safe Database Migration Patterns
affaan-m/ECC
Rules and examples for safe, reversible schema changes in production: zero-downtime column and index changes, large data backfills and ORM migration workflows.
276k GitHub stars~3.3k tokensUpdated yesterday
DatabasesAuto-check passed
Migrate Create
ruvnet/ruflo
Create a new sequentially numbered database migration with up/down SQL files
74k GitHub stars~583 tokensUpdated yesterday
DatabasesAuto-check: notes

Questions about Production Awid DB

What does Production Awid DB do?

Connect to the awid.ai production database for migrations, audits, and data operations. Production Awid DB is an agent skill from awebai/aweb.ai production database for migrations, audits, and data operations.

How do I install Production Awid DB in Claude Code?

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

How do I install Production Awid DB in Codex?

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

Can I use Production Awid DB 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 awebai/aweb --skill production-awid-db -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/production-awid-db, .gemini/skills/production-awid-db, .github/skills/production-awid-db and .opencode/skills/production-awid-db in your project.

What does Production Awid DB need to run?

Going by SKILL.md and its folder, Production Awid DB needs the command-line tools its instructions call (psql, uv and pg_dump). Our summary lists: Python 3.

Does Production Awid DB access the network?

SKILL.md contains no URLs. Its commands use uv, which can reach the network depending on how they are called. This is read from the text; nothing was executed.

Is Production Awid DB 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 Production Awid DB use?

Production Awid DB is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Production Awid DB use?

About 685 tokens (SKILL.md is roughly 2.7k 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 Production Awid DB?

Skills that share tags, products or a category with Production Awid DB: Reversible Migration (JuliusBrussee/caveman, 111k stars), Connect (ComposioHQ/awesome-claude-skills, 77k stars), Database Migrations (affaan-m/ECC, 277k stars) and Database Migrations (affaan-m/ECC, 277k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Production Awid DB?

awebai (a GitHub organization) maintains it in awebai/aweb, which has 115 GitHub stars. The repository holds 17 skills in this directory. The repository was last updated on October 10, 2026.

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

Install Production Awid DB

Facts

At a glance

What it does

Example prompts

Requirements

Workflow steps

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Context cost

Safety

SKILL.md

awid.ai production database operations

Credentials

Connecting

Common operations

Audit table counts

Check for orphan addresses (FK violation candidates)

Run migrations

Dump data

Schema reset (consolidation)

Notes

Files

Compare with similar skills

Similar skills

More from awebai/aweb

Questions about Production Awid DB