CodedByKay.ArtShow.Mcp

MCP server exposing the CodedByKay.ArtShow.CLI SQLite catalog (artwork.db) to MCP clients (Claude Code, Claude Desktop, etc), with full CRUD on artworks and classifiers.

This is a second writer of artwork.db alongside CodedByKay.ArtShow.CLI itself (see ArtShow.Workspace/AGENTS.md) — both talk to the same SQLite file in WAL mode, which supports that safely. It's DB-only, though: it never touches R2 or YouTube. Deleting/replacing an artwork's actual image files stays with the CLI's own "Delete artwork" / "Add artwork" flows, which own the R2 client and credentials.

Uses Node's built-in node:sqlite module (no native dependencies like better-sqlite3 to build/install) — requires Node.js 22.5+.

Setup

npm install
npm run build

Related MCP server: Rastro MCP

Tools

Read-only:

• list_artworks — filter/search artworks (id, type, category, medium, tag, group, title/description substring) with pagination and sorting.

• get_artwork — fetch one artwork by id.

• list_classifiers — known Category/Medium/Tag/Group values.

• get_catalog_stats — total/image/video counts plus per-value breakdowns.

• get_publish_state — whether the catalog has unpublished changes.

Mutating (all mark the catalog dirty / pending-publish, same as the CLI):

• create_artwork — insert a new row. Metadata only — pass an existing r2Key/thumbR2Key (already-uploaded image) or videoId (already on YouTube); new category/medium/tag/group values are auto-added to Classifiers, same as the CLI's Add flow.

• update_artwork — partial update by id; nullable fields can be explicitly set to null to clear them.

• delete_artwork — delete a row by id. Does not touch R2 — use the CLI's "Delete artwork" menu option for a delete that also removes the R2 files.

• create_classifier / rename_classifier / delete_classifier — manage known Category/Medium/Tag/Group values. Rename cascades to every artwork using that value; delete refuses (reporting the usage count) unless force: true, which also unlinks it from those artworks first.

• set_publish_dirty — manually set/clear the pending-publish flag.

Each artwork result includes the same imageUrl/thumbnailUrl/videoUrl fields the CLI's publish command writes to the site's data/artwork.json (built from R2Key/ThumbR2Key/VideoId), so results are ready to use without re-deriving URLs.

Configuration

• ARTSHOW_DB_PATH — override the path to artwork.db. Defaults to C:\Users\kaywi\dev\CodedByKay.ArtShow.CLI\Db\artwork.db.

• ARTSHOW_R2_PUBLIC_BASE_URL — override the R2 public base URL used to build imageUrl/thumbnailUrl. Defaults to https://kaysartshow.fyi.

Registering with a client

Example mcpServers entry (Claude Desktop / Claude Code MCP config):

{
  "mcpServers": {
    "artshow-catalog": {
      "command": "node",
      "args": ["C:\\Users\\kaywi\\dev\\CodedByKay.ArtShow.Mcp\\dist\\index.js"]
    }
  }
}

Or with the Claude Code CLI:

claude mcp add artshow-catalog -- node C:\Users\kaywi\dev\CodedByKay.ArtShow.Mcp\dist\index.js