Agent skill

Database Marchat

Changes marchat SQL schema and queries across SQLite, PostgreSQL, and MySQL using dialect helpers.

MITAuto-check passedDatabases

Install Database Marchat

skills CLI

$ npx skills add Cod-e-Codes/marchat --skill database-marchat -a claude-code

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

GitHub CLI

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

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 Cod-e-Codes/marchat --skill database-marchat -a codex

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

GitHub CLI

$ gh skill install Cod-e-Codes/marchat database-marchat --agent codex

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

Manual copy

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

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

GitHub CLI

$ gh skill install Cod-e-Codes/marchat database-marchat --agent cursor

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

Manual copy

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

--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 Cod-e-Codes/marchat --skill database-marchat -a gemini-cli

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

GitHub CLI

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

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 Cod-e-Codes/marchat --skill database-marchat -a github-copilot

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

Manual copy

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

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

Manual copy

$ git clone --depth 1 https://github.com/Cod-e-Codes/marchat.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.cursor/skills/database-marchat .opencode/skills/database-marchat && 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 "database-marchat" agent skill from https://github.com/Cod-e-Codes/marchat/tree/main/.cursor/skills/database-marchat into .opencode/skills/database-marchat/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "database-marchat", 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: database-marchat
GitHub stars: 137
Token cost: ~985 tokens
SKILL.md length: 419 words
Files: 1
Skills in repo: 11
Repo updated: Oct 3, 2026
First seen: Oct 7, 2026
Licence: MIT

At a glance

Changes marchat SQL schema and queries across SQLite, PostgreSQL, and MySQL using dialect helpers.

Works in 5 steps: Add a new migration step in… → MigrateSchema runs ordered migrations,… → Add or extend db_dialect_test.go for new… → …
Editing server/db.go
SKILL.md covers Rules, Durable tables, Testing and Schema change workflow, plus 2 more sections
Calls go

What it does

Database Marchat is an agent skill from Cod-e-Codes/marchat. Changes marchat SQL schema and queries across SQLite, PostgreSQL, and MySQL using dialect helpers. Use when editing server/db.go, dbdialect.go, schema migrations, MARCHATDBPATH, or multi-database behavior.

Its SKILL.md is about 990 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 Database migrations and SQL. It works with MySQL, PostgreSQL, SQLite and SQL. The repository describes itself as: Terminal chat for developers: Go WebSocket server + Bubble Tea TUI client, optional E2E, reactions, DMs, channels, plugins, files, code snippets, admin UI. Backends: SQLite… The licence is MIT.

When your agent uses it

Editing server/db.go
Schema migrations
Multi-database behavior

Example prompts

“Use the database-marchat skill to change marchat SQL schema and queries across SQLite, PostgreSQL, and MySQL using dialect helpers”
“/database-marchat”

Workflow steps

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

Add a new migration step in server/migrate.go (applyMigrationV2, etc.) and bump currentSchemaVersion; extend verifySchema when new…
MigrateSchema runs ordered migrations, records schema_version, and verifies required tables (including ban_history.expires_at)…
Add or extend db_dialect_test.go for new SQL fragments.
Run go test ./server/....
Document env or migration notes in ARCHITECTURE.md / CHANGELOG.md if user-visible.

What it can do on your machine

Read from SKILL.md and the folder at commit 3440f09. 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:
- go
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 no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Database Marchat loads about 985 tokens when it runs. Until then it costs about 56 tokens; SKILL.md has 419 words of instructions outside code blocks.

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

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

The full file from Cod-e-Codes/marchat at commit 3440f09, republished under its MIT licence (© Cod-e-Codes). 419 words, ~985 tokens.

Download SKILL.mdSave it as .claude/skills/database-marchat/SKILL.md (or your agent's skills folder).

name: database-marchat
description: Changes marchat SQL schema and queries across SQLite, PostgreSQL, and MySQL using dialect helpers. Use when editing server/db.go, db_dialect.go, schema migrations, MARCHAT_DB_PATH, or multi-database behavior.
paths: server/db.go, server/db_dialect.go, server/migrate.go, server/db_*_test.go, server/migrate_test.go, server/handlers.go, server/message_state.go

Database (marchat)

Runtime backend via MARCHAT_DB_PATH: SQLite (default), PostgreSQL, or MySQL. Detection and DSN parsing: server/db_dialect.go, InitDB in server/db.go.

Rules

Parameterized queries only; no string-concatenated user input.
Every schema or query change must work on all three dialects (or use db_dialect.go helpers).
SQLite (InitDB only):
- Put connection pragmas in the DSN so every pooled connection gets them (_busy_timeout=5000, _journal_mode=WAL, _synchronous=NORMAL, _txlock=immediate on the writer, plus _pragma for cache/temp). Join with ? or & if the path already has a query (appendSQLiteDSNPragmas).
- After Ping, set writer SetMaxOpenConns(1) and SetMaxIdleConns(1). For file-backed SQLite, open a sibling reader pool (MaxOpenConns(4), _query_only=1, same busy_timeout; no _journal_mode, no mode=ro, no cache=shared). Route SELECTs through dbRead(db). Close with CloseDB. Do not leave the default unbounded database/sql pool on the writer.
- Do not split :memory: (each connection is a different database).
- Do not rely on one-shot Exec("PRAGMA ...") after open for settings that must stick on every connection (that was the #118 SQLITE_BUSY failure mode).
- Verify after open: busy_timeout > 0; for file-backed DBs, journal_mode is wal. In-memory (:memory: / mode=memory) requires busy_timeout only.
- Quote paths safely in VACUUM INTO and similar.
Postgres/MySQL: leave pool defaults alone (do not force MaxOpenConns(1)).
MySQL: DSN via mysql: or mysql://; mysql.Config with parseTime=true; indexed text rules for search.
Postgres: boolean columns need dialect boolean literals, not = 0 / = 1.

Durable tables

Include messages plus durable state: reactions, read receipts, user_message_state, channel preferences. Not message rows alone.

Show full SKILL.md (189 more words)Show less

Testing

Level	Where
Unit / integration	In-memory or temp SQLite in `server/*_test.go` (`db_test.go` covers DSN join, file WAL, `:memory:`, concurrent inserts)
CI smoke	`server/db_ci_smoke_test.go` with `MARCHAT_CI_POSTGRES_URL`, `MARCHAT_CI_MYSQL_URL` (also asserts pool is not forced to 1)
Handlers	Visible replay SQL (`GetRecentMessagesForUser`), search, pin toggle

Locally, CI smoke tests skip without env vars. See testing-marchat skill.

Schema change workflow

Add a new migration step in server/migrate.go (applyMigrationV2, etc.) and bump currentSchemaVersion; extend verifySchema when new required tables or columns ship. Prefer deterministic DDL for versions after the v1 baseline (avoid inspect-and-reconcile).
MigrateSchema runs ordered migrations, records schema_version, and verifies required tables (including ban_history.expires_at). SQLite/Postgres wrap each version in a transaction; MySQL cannot (DDL implicit commit) - document that when changing migrator behavior. CreateSchema in the same file is a thin log.Fatal wrapper for tests.
Add or extend db_dialect_test.go for new SQL fragments.
Run go test ./server/....
Document env or migration notes in ARCHITECTURE.md / CHANGELOG.md if user-visible.

Backup

In-process :backup supports SQLite only. Postgres and MySQL require native backup tools; BackupDatabase returns an error when dialect is not SQLite.

References

ARCHITECTURE.md database section
internal/doctor DB probes for -doctor output

Files

Just SKILL.md in .cursor/skills/database-marchat of Cod-e-Codes/marchat.

Open the folder on GitHubat commit 3440f09

Compare with similar skills

Database Marchat 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 Marchat compared with similar skills
Skill	Stars	Used in	Tokens	Auto-check	Licence	Repo updated
Database Marchat this skillCod-e-Codes/marchat	137	—	~985	Automated safety check: Pass	MIT	5 days ago
SQL Database Support for pRESTprest/prest	4.6k	—	~1.6k	Automated safety check: Pass	MIT	2 days ago
Squixeduardofuncao/squix	273	—	~784	Automated safety check: Pass	MIT	15 days ago
Golang Databaseunxed/f4	240	2 repos	~2.9k	Automated safety check: Pass	MIT	today
Database Migrations SQL Migrationsrmyndharis/antigravity-skills	1.7k	2 repos	~577	Automated safety check: Notes	MIT	7 days ago
Database MigrationRain-kl/OpenFlare	288	—	~1.3k	Automated safety check: Pass	Apache-2.0	today

Similar skills

SQL Database Support for pREST
prest/prest
Guides classifying, gap-analyzing and scaffolding support for a new SQL database in pREST, from Postgres-compatible variants to entirely new dialects.
4.6k GitHub stars~1.6k tokensUpdated 2 days ago
DatabasesAuto-check passed
Squix
eduardofuncao/squix
Run SQL queries across databases (Postgres, MySQL, SQLite, etc.) via the squix CLI.
273 GitHub stars~784 tokensUpdated 15 days ago
DatabasesAuto-check passed
Golang Database
unxed/f4
Comprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context…
240 GitHub starsUsed in 2 repos~2.9k tokens
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 2 repos~577 tokens
DatabasesAuto-check: notes
Database Migration
Rain-kl/OpenFlare
Wavelet 项目专用：当新增或修改数据库表结构、索引、初始化数据、系统配置 seed、模板 seed、默认管理员、goose SQL 迁移、internal/infra/persistence/migrator、ClickHouse 分析库 DDL 或数据库升级流程时必须使用。本技能指导在 internal/infra/persistence/migrator/goose 下编写…
288 GitHub stars~1.3k tokensUpdated today
DatabasesAuto-check passed
Database
iii-hq/workers
Run SQL against PostgreSQL, MySQL, or SQLite from the iii engine — reads, writes, transactions, and prepared statements over managed connection pools.
113 GitHub stars~1.9k tokensUpdated yesterday
DatabasesAuto-check passed

Questions about Database Marchat

What does Database Marchat do?

Changes marchat SQL schema and queries across SQLite, PostgreSQL, and MySQL using dialect helpers. Database Marchat is an agent skill from Cod-e-Codes/marchat. Changes marchat SQL schema and queries across SQLite, PostgreSQL, and MySQL using dialect helpers.

When should I use Database Marchat?

Database Marchat fits situations like: editing server/db.go; schema migrations; multi-database behavior.

How do I install Database Marchat in Claude Code?

Run `npx skills add Cod-e-Codes/marchat --skill database-marchat -a claude-code`. Or copy the skill folder (.cursor/skills/database-marchat in Cod-e-Codes/marchat) into .claude/skills/database-marchat in your project. Claude Code loads it when a task matches its description.

How do I install Database Marchat in Codex?

Run `npx skills add Cod-e-Codes/marchat --skill database-marchat -a codex`. Or copy the skill folder (.cursor/skills/database-marchat in Cod-e-Codes/marchat) into .agents/skills/database-marchat in your project. Codex loads it when a task matches its description.

Can I use Database Marchat 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 Cod-e-Codes/marchat --skill database-marchat -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-marchat, .gemini/skills/database-marchat, .github/skills/database-marchat and .opencode/skills/database-marchat in your project.

What does Database Marchat need to run?

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

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

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

About 985 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 Marchat?

Skills that share tags, products or a category with Database Marchat: SQL Database Support for pREST (prest/prest, 4.6k stars), Squix (eduardofuncao/squix, 273 stars), Golang Database (unxed/f4, 240 stars) and Database Migrations SQL Migrations (rmyndharis/antigravity-skills, 1.7k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Database Marchat?

Cod-e-Codes (a GitHub user) maintains it in Cod-e-Codes/marchat, which has 137 GitHub stars. The repository holds 11 skills in this directory. The repository was last updated on October 3, 2026.

Source: Cod-e-Codes/marchat on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.

Database Marchat

Install Database Marchat

Facts

At a glance

What it does

When your agent uses it

Example prompts

Workflow steps

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Context cost

Safety

SKILL.md

Database (marchat)

Rules

Durable tables

Testing

Schema change workflow

Backup

References

Files

Compare with similar skills

Similar skills

SQL Database Support for pREST

Squix

Golang Database

Database Migrations SQL Migrations

Database Migration

Database

More from Cod-e-Codes/marchat

Debugging Marchat

Developing Marchat

Git Workflow Marchat

Testing Marchat

Client Marchat

Plugins Marchat

Questions about Database Marchat

Install Database Marchat

Facts

At a glance

What it does

When your agent uses it

Example prompts

Workflow steps

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Context cost

Safety

SKILL.md

Database (marchat)

Rules

Durable tables

Testing

Schema change workflow

Backup

References

Files

Compare with similar skills

Similar skills

More from Cod-e-Codes/marchat

Related

Questions about Database Marchat