What is the key difference between Amnesic and MCP Clickhouse?

Amnesic belongs to the Databases category with local stdio execution, while MCP Clickhouse belongs to the Databases category with local stdio execution.

How do I install Amnesic or MCP Clickhouse in Claude Desktop or Cursor?

Copy the mcpServers JSON configuration snippet provided on this page into your claude_desktop_config.json or ~/.cursor/mcp.json file and restart your AI client.

Are Amnesic and MCP Clickhouse free or paid?

Amnesic operates under a Free / Open Source model (other). MCP Clickhouse operates under a Free / Open Source model (other).

Which MCP server has more tools and community activity?

Amnesic lists 6 tools with 2 views and 3 GitHub stars. MCP Clickhouse lists 3 tools with 3 views and 872 GitHub stars.

Can I use both Amnesic and MCP Clickhouse together in the same MCP host?

Yes! MCP hosts like Claude Desktop, Cursor, Windsurf, Cline, and VS Code support configuring multiple servers under the mcpServers object simultaneously.

Side-by-Side Model Context Protocol Comparison

Amnesic vs MCP Clickhouse

In-depth architectural comparison of the Amnesic and MCP Clickhouse MCP servers. Compare execution transports, security boundaries, tool capabilities, quality scores, and ready-to-paste client installation snippets for Claude, Cursor, Windsurf, and VS Code.

At a Glance & Executive Verdict

Amnesic

Databases · Local stdio

Quality: 55/100 (Good) | Auth: other

MCP Clickhouse

Databases · Local stdio

Quality: 65/100 (Great) | Auth: other

Verdict Summary: Choose Amnesic if you need specialized Databases tools running via a local process. Choose MCP Clickhouse if your workspace requires Databases integration with local subprocess execution. Both servers can be configured concurrently in your client's mcpServers manifest.

Which MCP Server Should You Choose?

Choose Amnesic when:

You need dedicated capabilities in the Databases domain.
You prefer local stdio subprocess transport architecture.
Your security boundary fits: other (Free / Open Source).
Primary tools included: Persistent per-database SQLite knowledge stores, Table and column annotations, Foreign-key relationship graph.

Explore Amnesic Details

Choose MCP Clickhouse when:

You need dedicated capabilities in the Databases domain.
You prefer local stdio subprocess transport architecture.
Your security boundary fits: other (Free / Open Source).
Primary tools included: list_databases, list_tables, run_query.

Explore MCP Clickhouse Details

Feature & Specification Comparison

Specification	Amnesic SurajKGoyal Databases	MCP Clickhouse ClickHouse Databases
Summary	The MCP server that remembers your database — persists table/column annotations, an FK relationship graph, and searchable notes across sessions, so the model stops re-discovering your schema every time. PostgreSQL, MySQL, MSSQL, SQLite; read-only-enforced.	ClickHouse database integration with schema inspection and query capabilities
Category & Scope	Databases

Tools & Capabilities Breakdown

Amnesic Tools (6)

Persistent per-database SQLite knowledge stores

Table and column annotations

Foreign-key relationship graph

Searchable database notes

PostgreSQL, MySQL, MSSQL, and SQLite support

Static SQL checks and transaction rollback for read-only enforcement

MCP Clickhouse Tools (3)

list_databases

Ready-to-Paste Client Configurations

Paste either (or both) of these JSON server blocks into your client config file (e.g. claude_desktop_config.json or ~/.cursor/mcp.json).

Amnesic Configuration

mcpServers (Claude Desktop / Cursor)

{
  "mcpServers": {
    "surajkgoyal-amnesic": {
      "command": "uvx",
      "args": [
        "caches"
      ]
    }
  }
}

MCP Clickhouse Configuration

mcpServers (Claude Desktop / Cursor)

{
  "mcpServers": {
    "clickhouse-mcp-clickhouse": {
      "command": "uvx",
      "args": [
        "mcp-clickhouse"
      ]
    }
  }
}

Frequently Asked Questions

Amnesic is categorized under Databases and uses a local stdio subprocess. In contrast, MCP Clickhouse belongs to Databases using local stdio subprocess. Select Amnesic when you need capabilities focused on databases and MCP Clickhouse when you require tools for databases.

More alternatives to Amnesic More alternatives to MCP Clickhouse Databases category hub Canonical compare URL