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).

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

Response:

📊 Database Schema

This MCP uses the following table structure:

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

Smithery (Recommended)

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

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

Response:

• Shows how many posts were collected

• Shows how many were new vs updated

• Handles duplicates automatically with UPSERT

📝 License

MIT