Amnesic

by SurajKGoyal

273 downloads Not rated yet

GitHub Website

Database
AI

About

Persistent semantic memory for SQL databases (Postgres, MySQL, MSSQL, SQLite). Annotate once, remember forever.

Explore

- Persistent SQLite knowledge store per database
- Read‑only by design with two independent safety layers
- Supports PostgreSQL, MySQL/MariaDB, SQL Server, and SQLite
- Credentials never appear in tool responses
- Nine MCP tools for schema, query, and annotation management

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below

Plugin Name Amnesic

Command (node, npx, python, etc.)

Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "amnesic": {
            "amnesic": {
                "command": "uvx",
                "args": [
                    "--from",
                    "amnesic[all]",
                    "amnesic"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "amnesic": {
            "amnesic": {
                "command": "uvx",
                "args": [
                    "--from",
                    "amnesic[all]",
                    "amnesic"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "amnesic": {
            "amnesic": {
                "command": "uvx",
                "args": [
                    "--from",
                    "amnesic[all]",
                    "amnesic"
                ]
            }
        }
    }
}

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

{
    "mcpServers": {
        "amnesic": {
            "amnesic": {
                "command": "uvx",
                "args": [
                    "--from",
                    "amnesic[all]",
                    "amnesic"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "amnesic": {
            "amnesic": {
                "command": "uvx",
                "args": [
                    "--from",
                    "amnesic[all]",
                    "amnesic"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "amnesic": {
            "amnesic": {
                "command": "uvx",
                "args": [
                    "--from",
                    "amnesic[all]",
                    "amnesic"
                ]
            }
        }
    }
}

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "amnesic": {
            "amnesic": {
                "command": "uvx",
                "args": [
                    "--from",
                    "amnesic[all]",
                    "amnesic"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "amnesic": {
            "amnesic": {
                "command": "uvx",
                "args": [
                    "--from",
                    "amnesic[all]",
                    "amnesic"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "amnesic": {
            "amnesic": {
                "command": "uvx",
                "args": [
                    "--from",
                    "amnesic[all]",
                    "amnesic"
                ]
            }
        }
    }
}

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

{
    "mcpServers": {
        "amnesic": {
            "amnesic": {
                "command": "uvx",
                "args": [
                    "--from",
                    "amnesic[all]",
                    "amnesic"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "amnesic": {
            "amnesic": {
                "command": "uvx",
                "args": [
                    "--from",
                    "amnesic[all]",
                    "amnesic"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "amnesic": {
            "amnesic": {
                "command": "uvx",
                "args": [
                    "--from",
                    "amnesic[all]",
                    "amnesic"
                ]
            }
        }
    }
}

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "amnesic": {
            "amnesic": {
                "command": "uvx",
                "args": [
                    "--from",
                    "amnesic[all]",
                    "amnesic"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "amnesic": {
            "amnesic": {
                "command": "uvx",
                "args": [
                    "--from",
                    "amnesic[all]",
                    "amnesic"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "amnesic": {
            "amnesic": {
                "command": "uvx",
                "args": [
                    "--from",
                    "amnesic[all]",
                    "amnesic"
                ]
            }
        }
    }
}

From the repository

Install with pipx install amnesic and run amnesic init to set up connections. The server exposes nine MCP tools for listing connections, querying schemas, executing read‑only SELECT queries, annotating database semantics, and managing knowledge across connections.

`db_list_connections`

List configured connections (no secrets)

`db_list_tables`

All known tables with descriptions

`db_search`

BM25 search over table/column knowledge

`db_get_schema`

Column schema merged with saved annotations

`db_query`

Execute a read-only SELECT

`db_annotate`

Persist semantic annotations (enum meanings, FKs)

`db_sync_knowledge`

Copy annotations between connections (staging → prod)

`db_discover_relationships`

Discover all FK relationships from the live DB

`db_get_relationships`

Navigate the FK graph for JOIN planning

| Tool | Description |
|------|-------------|
| db_list_connections | List configured connections (no secrets) |
| db_list_tables | All known tables with descriptions |
| db_search | BM25 search over table/column knowledge |
| db_get_schema | Column schema merged with saved annotations |
| db_query | Execute a read-only SELECT |
| db_annotate | Persist semantic annotations (enum meanings, FKs) |
| db_sync_knowledge | Copy annotations between connections (staging → prod) |
| db_discover_relationships | Discover all FK relationships from the live DB |
| db_get_relationships | Navigate the FK graph for JOIN planning |

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "amnesic": {
            "amnesic": {
                "command": "uvx",
                "args": [
                    "--from",
                    "amnesic[all]",
                    "amnesic"
                ]
            }
        }
    }
}

McpServers

{
    "amnesic": {
        "command": "uvx",
        "args": [
            "--from",
            "amnesic[all]",
            "amnesic"
        ]
    }
}

Persistent semantic memory for your SQL databases. The name is ironic — it remembers everything. Every session with an AI starts cold: you re-explain what tables exist, what a status value of 3 means, which foreign key connects orders to users. amnesic fixes this with a local SQLite knowledge store — one per database — that survives across sessions. Annotate an enum once; every future session sees those labels automatically.

🔒 Read-only by design

Safe to point at production. Two independent layers: static SQL analysis rejects any write/DDL statement before connecting, and every query runs inside a transaction that is immediately rolled back. Credentials never appear in tool responses.

Supported databases

PostgreSQL · MySQL / MariaDB · Microsoft SQL Server · SQLite

Tools

| Tool | Description | |------|-------------| | db_list_connections | List configured connections (no secrets) | | db_list_tables | All known tables with descriptions | | db_search | BM25 search over table/column knowledge | | db_get_schema | Column schema merged with saved annotations | | db_query | Execute a read-only SELECT | | db_annotate | Persist semantic annotations (enum meanings, FKs) | | db_sync_knowledge | Copy annotations between connections (staging → prod) | | db_discover_relationships | Discover all FK relationships from the live DB | | db_get_relationships | Navigate the FK graph for JOIN planning |

Install

```bash pipx install amnesic amnesic init # interactive setup wizard

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

About

Explore

Setting up with Highlight

From the repository

db_list_connections

db_list_tables

db_search

db_get_schema

db_query

db_annotate

db_sync_knowledge

db_discover_relationships

db_get_relationships

Claude Desktop / Cursor

McpServers

🔒 Read-only by design

Supported databases

Tools

Install

More like this

Redis

Sqlite

PostgreSQL

Context 7

`db_list_connections`

`db_list_tables`

`db_search`

`db_get_schema`

`db_query`

`db_annotate`

`db_sync_knowledge`

`db_discover_relationships`

`db_get_relationships`