Persistent semantic memory for SQL databases (Postgres, MySQL, MSSQL, SQLite). Annotate once, remember forever.
Overview
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
pipx install amnesic
amnesic init # interactive setup wizard
Server Config
{
"mcpServers": {
"amnesic": {
"command": "amnesic"
}
}
}