A
licenseNot graded
qualityC
maintenanceDrop-in MCP server template with SQLite FTS5 search backend. ~300 lines, no vector DB, no embedding API, runs on a Pi.
MIT
melty
Provides full-text search and retrieval of messages and threads from a Discord server exported to SQLite. Tools include search, get_thread, channel_search, get_messages, list_channels, and stats.
Provides read-only SQL query access to the underlying SQLite database containing exported Discord messages, enabling custom data exploration.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@meltysearch "login error" after 2024-01-01"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
melty
MCP server with FTS5 full-text search over a SQLite export of a discord server.
The canonical repo is hosted on Tangled at dunkirk.sh/melty.
Setup
bun install
cp .env.example .env
# Edit .env with your Discord token and guild IDExport Discord data
bun run export # Exports messages to discord-export/melty.db (resumable)After export completes, build the thread index:
bun run src/build-threads.tsRun the MCP server
bun run mcpOr configure it in your MCP client:
{
"mcp": {
"melty-discord": {
"command": "bun",
"args": ["run", "./src/mcp-server.ts"],
"type": "stdio"
}
}
}Related MCP server: Discord Message Finder MCP
MCP Tools
Tool | Description |
| Full-text search across conversation threads (FTS5 with BM25 ranking). Start here. |
| Read full text of a thread by ID. Use after |
| Same as |
| Paginated raw message access within a channel, newest-first. |
| All channels with message counts, grouped by category. |
| Database statistics: total messages, threads, authors, date range. |
| Raw read-only SQL against the database. Escape hatch. |
Search syntax
Supports FTS5 query syntax:
word— matches any thread containing "word""exact phrase"— exact phrase matchsearch*— prefix matchapple AND banana— both terms requiredapple OR banana— either termapple NOT banana— exclude term
Optional filters: after/before (ISO-8601 timestamps), author (name substring).
This server cannot be deployed
Maintenance
ActivityStale
ResponsivenessNo issues
Related MCP Connectors
Search your AI chat history (ChatGPT, Claude, Codex) from any MCP client. Remote, private, read-only
An MCP server that provides congressional transcripts
MCP server for querying Forkast documentation
Related MCP Servers
- FlicenseAqualityDmaintenanceRead-only MCP server for finding Discord messages. It enables searching guild messages, locating messages from jump URLs, and reading context around results.71-
- AlicenseAqualityDmaintenancePersistent memory MCP server with FTS5 fuzzy search, storing data in SQLite with automatic maintenance and token-efficient TOON output.3161MIT
- AlicenseAqualityCmaintenanceMCP server for local knowledge management with Markdown and PDF indexing using SQLite FTS5.5122MIT