How do I install the DB Write skill?

Run npx skillmds@latest add kevin-liu-01/db-write in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

What does the DB Write skill do?

Run mutating SQL (INSERT, UPDATE, DELETE, DDL) against Supabase databases. Requires explicit user invocation. Use for migrations, seed data, schema changes, or data fixes. It is listed under Data & Analytics on SkillMD.

Is DB Write safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with DB Write?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is DB Write free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published DB Write?

kevin-liu-01 (@kevin-liu-01) published this skill. Their other Agent Skills are listed on their SkillMD profile.

DB Write by kevin-liu-01 — Agent Skill

Name: DB Write
Author: kevin-liu-01

File contents

Context

Databases: !cat packages/python/cli/databases.yml
Local Supabase status: !pnpm db status 2>&1 | head -10

Query script

The query tool lives at ${CLAUDE_SKILL_DIR}/../db/scripts/query.ts. Run it with:

node --experimental-strip-types ${CLAUDE_SKILL_DIR}/../db/scripts/query.ts [flags] "<sql>"

Flags:

--env local|dev|preview|prod (default: local)
--db core|admin (default: core)
--format table|json|csv (default: table)

Note: do NOT pass --readonly. This skill is for mutations.

Credentials

Same as /db. See that skill for credential resolution order and SSM instructions.

Schema reference

Generated Supabase types with full table schemas, enums, and function signatures:

Core DB: packages/typescript/databases/core/database.types.ts
Admin DB: packages/typescript/databases/admin/database.types.ts

Read the relevant file when you need column names, types, enums, or relationships.

Rules

NEVER target prod. Refuse all prod mutations. Production changes go through migrations deployed via the pipeline (dev -> preview -> prod). See AGENTS.md "Production is Sacred."
Confirm before executing on any remote environment (dev, preview). Show the SQL and target environment, then ask the user to confirm.
Default to --env local unless the user specifies otherwise.
For DDL (CREATE, ALTER, DROP), prefer pnpm db diff --execute for tracked migrations. Only use raw DDL for local experimentation.
Show the SQL you intend to run before running it.

Task

Run the user's mutation. Always show the SQL and target before executing. For remote envs, require explicit confirmation.

$ARGUMENTS

Frequently asked questions

DB Write