Skip to main content
Glama
Danbooru-Turso MCP Server

Danbooru-Turso MCP Server

by gamzadongza

Danbooru-Turso MCP Server

Simple MCP server for collecting Danbooru character data and storing it in Turso database.

🎯 Purpose

Automatically collect and save Danbooru character data to Turso cloud database with automatic upsert (updates existing posts).

Related MCP server: alaya

✨ Features

  • πŸ“₯ Collect character data from Danbooru API with automatic pagination

  • πŸ’Ύ Store in Turso cloud database

  • πŸ”„ Auto-update existing posts (INSERT OR REPLACE)

  • ⚑ Fast & Simple - Single tool, single purpose

πŸ› οΈ Tool

collect_and_save

Collect all posts for a character tag and save to Turso database.

Parameters:

  • tag (required): Character tag to collect (e.g., "yatogami_tenka")

  • max_posts (optional): Maximum number of posts to collect

Example:

{
  "tag": "yatogami_tenka",
  "max_posts": 1000
}

Response:

{
  "success": true,
  "tag": "yatogami_tenka",
  "collected": 119,

  "new_posts": 111,
  "updated_posts": 8
}

πŸ“Š Database Schema

This MCP uses the following table structure:

CREATE TABLE IF NOT EXISTS posts (
  id INTEGER PRIMARY KEY,
  tags TEXT NOT NULL,
  tag_count INTEGER NOT NULL,
  rating TEXT NOT NULL,
  score INTEGER NOT NULL,
  fav_count INTEGER NOT NULL,
  file_url TEXT NOT NULL,
  pixiv_id INTEGER
);

Note: If you need additional fields (like image_width, image_height, created_at, etc.), you can modify src/services/turso.ts to include them. The table is only created if it doesn't exist (CREATE TABLE IF NOT EXISTS), so existing data is safe.

Danbooru API returns 50+ fields per post. This MCP stores the most commonly used fields for performance and simplicity. The current schema covers the essential data for most use cases.

πŸš€ Deployment

  1. Push to GitHub

  2. Deploy on Smithery with environment variables:

    • TURSO_DATABASE_URL - Your Turso database URL

    • TURSO_AUTH_TOKEN - Your Turso auth token

Local Development


npm install
npm run build
npm start

πŸ“¦ Environment Variables

  • TURSO_DATABASE_URL - Turso database URL (required)

  • TURSO_AUTH_TOKEN - Turso auth token (required)

  • PORT - Server port (default: 3000)

πŸ“– Usage Example

Collect data:

collect_and_save({ 
  tag: "yatogami_tenka",
  max_posts: 500 
})

Response:

  • Shows how many posts were collected

  • Shows how many were new vs updated

  • Handles duplicates automatically with UPSERT

πŸ“ License

MIT

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    Related MCP Connectors

    Related MCP Servers

    • F
      license
      Not graded
      quality
      D
      maintenance
      Archives posts from X into a local SQLite database and provides tools for semantic analysis and natural language search. It enables agents to manage low-cost data ingestion and retrieve relevant posts using local embeddings and topic labeling.
      3
      -
    • A
      license
      Not graded
      quality
      D
      maintenance
      A local memory engine for AI agents. Stores conversation episodes, consolidates knowledge through a neuroscience-inspired lifecycle, and builds a personal knowledge graph β€” all in a local SQLite database.
      20
      MIT
    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables AI assistants to store and retrieve long-term memories with semantic search, supporting various memory types and tags via PostgreSQL and pgvector.
      11 npm
      MIT
    • A
      license
      A
      quality
      A
      maintenance
      Self-hosted long-term memory gateway for AI clients, deployed to your own Cloudflare account (Workers + D1 + Vectorize). It captures conversations, consolidates them overnight, and exposes MCP tools to search, recall and write memories from any MCP client.
      10
      151
      AGPL 3.0