Amnesic MCP server
io.github.SurajKGoyal/amnesic·v0.2.2·3 starsPersistent semantic memory for SQL databases. Postgres, MySQL, MSSQL, SQLite.
3 stars82 downloads/wk
Reviews
Write oneNobody has reviewed Amnesic yet.
If you have run it, two minutes of your experience saves the next person an afternoon.
Amnesic tools (12, 1 write)
write = sends, deletes, buys or postsRead from the package source without running it. The installed server may list more.
db_annotatePersist semantic annotations for a table or column — survives across sessions.
db_deprecateSoft-retire a table or column annotation — flag it stale without deleting it.
db_detect_driftAudit saved annotations against the live database schema (read-only).
db_discover_relationshipsDiscover all foreign key relationships in the database and save them to the graph.
db_forgetPermanently delete a table or column annotation. Safe by default — NOT reversible.
db_get_relationshipsGet the foreign key relationship graph for a table up to the given traversal depth.
db_get_schemaGet column schema for a table, merged with any saved semantic annotations.
db_list_connectionsList all configured database connections without exposing passwords or usernames.
db_list_tablesList all known tables for a connection, with descriptions and column counts.
db_querywrite actionExecute a read-only SELECT query and return rows as a list of dicts.
db_searchSearch the knowledge layer for tables/columns matching a query — BM25-ranked.
db_sync_knowledgeCopy annotations from one connection's knowledge store to another.
Public scan report
scanner v0.1.9 · 2026-09-26 · same rubric, same numbers if you re-run it
- Code scan23 source files scanned25/25
- –Live reliabilityno gateway calls yet and no remote to proben/a
- –Tool poisoningtools not inspected (local package is not executed); not countedn/a
- Auth qualitylocal package, no credentials required12/15
- Maintenancelast push 0 days ago15/15
- Maintainer identityregistry namespace matches repository owner; GitHub account older than a year8/10
How Amnesic compares
Against every graded Databases MCP server, from our own scans and uptime checks. Updated after each scan run.
- Safety score
- 92/100
- higher than 90% of 802 Databases servers
- Tools
- 12
- the typical Databases server has 8
- Tools that change things
- 8%
- typical: 9%. Fewer write tools means less an agent can break
- GitHub stars
- 3
- more than 65% of 602 Databases servers
- Downloads a week
- 82
- more than 51% of 330 Databases servers with a package
What its tools let an agent do: 11 read · 1 change
Install Amnesic in Claude Code, Cursor or VS Code
claude mcp add amnesic -- uvx amnesic
What the publisher says
From the Amnesic repository's README, as published. We do not edit it. Read it on GitHub
amnesic — the MCP server with the most ironic name in the registry
Your database's institutional memory, as an MCP server. The name is ironic — it remembers everything.
"The MCP server with the most ironic name in the registry. It's anything but amnesic — it remembers your database so your AI doesn't have to."
Most database MCP servers are query executors: they connect, introspect, run SQL, and forget. amnesic is a semantic memory — it accumulates what your schema means (what status = 3 is, which columns are really foreign keys, what that legacy table is for) and hands it to every future session automatically. Think data catalog, minus the platform, the ingestion pipeline, and the invoice. Where amnesic fits ↓
Works with Claude Code · Claude Desktop · Cursor · VS Code · Cline · Windsurf — any MCP-compatible client.
Available on Official MCP Registry · Claude Code plugin marketplace
👋 Using amnesic? Say hi in the adopters thread — download counts can't tell me what's actually being used, and it directly shapes what gets built next.
🔒 Read-only by design. amnesic refuses to execute INSERT, UPDATE, DELETE, DROP, TRUNCATE, ALTER, CREATE, EXEC, MERGE, GRANT, REVOKE — and any write statement smuggled inside a WITH CTE. Two layers of defense: static SQL analysis rejects the statement before connecting, and every query runs inside a transaction that is immediately rolled back. Safe to point at prod. Details ↓
The problem
Every session with an AI starts cold. You spend the first few minutes re-explaining what tables exist, what a status column value of 3 means, which FK connects orders to users. Then the session ends, and you do it all over again tomorrow.
amnesic fixes this. It gives your AI a persistent SQLite knowledge store — one per database — that survives across sessions. Annotate a status enum once; every future session sees those labels automatically. Discover FK relationships once; every future JOIN query uses that graph.
The knowledge is also portable and outlives your access to the database. When you rotate off a project, amnesic export hands the next developer everything you taught it — years of "oh, that column actually means…" that would otherwise leave with you.
Where amnesic fits
The database MCP ecosystem splits into two camps, and amnesic is deliberately in neither.
Shortened. The full README is on GitHub.
Nothing above is checked by us. What we check is on the safety report.
Amnesic: common questions
- Is Amnesic MCP server safe?
- Yes, by our scan: it is graded A (92/100). Read the Amnesic safety report
- How do I install Amnesic?
- It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.
- Does Amnesic need an API key?
- Not as far as the registry entry and our scan can tell: no credentials are declared or required.
- Is Amnesic maintained?
- The last commit was 40 days ago (2026-09-26). The latest release is v0.2.2.
- What can I use instead of Amnesic?
- Servers from other publishers that do the same job: DBHub MCP server, Appwrite MCP server and Faucet MCP server. Compare all Amnesic alternatives.
- How does Amnesic compare with other Databases MCP servers?
- safety score 92/100 (higher than 90% of 802 Databases servers); tools 12 (the typical Databases server has 8); tools that change things 8% (typical: 9%. Fewer write tools means less an agent can break). Full comparison.
Alternatives to Amnesic
Same job from other publishers: the closest match first, then the best rated.
- DBHubToken-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLitenot reviewedWidely usedA
- AppwriteBuild and deploy backends: auth, Postgres/MySQL/vector databases, storage, functions, hosting, CDNnot reviewedEstablishedA
- FaucetSQL database to MCP tools and REST API: PostgreSQL, MySQL, SQL Server, Oracle, SQLite, Snowflake.not reviewedEstablishedA
- ZenBrain MemoryAgent memory: working, episodic, semantic, procedural and core layers. Local SQLite, no account.not reviewedGrowingA
- Local MemoryPersistent local AI memory. SQLite + FTS5 + vector search, knowledge graph. No cloud, no API keys.not reviewedGrowingA