Amnesic

Created By

SurajKGoyal2 months ago

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

# database

# sql

Overview Content Tools Comments

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

Try in Playground

Server Config

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

Project Info

Created At

2 months ago

Updated At

a month ago

Author Name

SurajKGoyal

Star

Language

License

Recommend Servers

View All

Puppeteer

@modelcontextprotocol

Browser automation and web scraping

a year ago

Sequential Thinking

@modelcontextprotocol

An MCP server implementation that provides a tool for dynamic and reflective problem-solving through a structured thinking process.

a year ago

ShareMyPage

@Henning Witzel-Acikgöz

Host the HTML or Markdown pages your AI generates and share each as a link with comments, versioning, and access control. Create, update, and organize pages and read reviewer comments over MCP.

12 days ago

12 days ago

12 days ago

12 days ago

Ready for a new way to bill pay? Pay any bill in a snap, right from a chat. Describe or snap a photo of your bill (electric, water, gas, internet, phone, medical, credit card, rent, parking tickets, traffic violations and more) and Papaya reads it, then hands you a secure link to pay by card. Fast, secure, and no juggling twelve logins, with full or partial payments and status updates. Powered by Papaya (papayapay.com).

12 days ago

Portugal Payments Mcp

12 days ago

12 days ago

12 days ago

12 days ago

@modelcontextprotocol

A Model Context Protocol server that provides access to Redis databases. This server enables LLMs to interact with Redis key-value stores through a set of standardized tools.

a year ago

Filesystem

Secure file operations with configurable access controls

a year ago

EdgeOne Pages MCP

@TencentEdgeOne

An MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.

TypeScript

a year ago

12 days ago

A Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.

JavaScript

a year ago

Concordance

@matharrismma

Language models generate; Concordance verifies. The verify tool checks a claim deterministically (no model in the loop) and returns HOLDS / BROKEN / INCOMPLETE with the worked reasoning and a sealed receipt (content_hash + cite_url) that re-fetches byte-identical or not at all. Also: ranked search over an ~11k-record library, seal_fetch to re-verify any receipt, redact to strip PII before text travels, and a sealed connection graph. Runs sovereign/offline too (stdlib-first Python). A public false-positive benchmark covers every domain: the engine has never sealed a falsehood. 38 tools live; remote endpoint at https://narrowhighway.com/mcp.

12 days ago

Uganda Payments Mcp

@junter1989k-ai

12 days ago

Perplexity Ask MCP Server

@ppl-ai

A Model Context Protocol Server connector for Perplexity API, to enable web search without leaving the MCP ecosystem.

JavaScript

a year ago

Aws Kb Retrieval Server

@modelcontextprotocol

An MCP server implementation for retrieving information from the AWS Knowledge Base using the Bedrock Agent Runtime.

a year ago

Aiimagemultistyle

@codecraftm

A Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.

a year ago

12 days ago

Public, read-only MCP over the complete 64-hexagram I Ching corpus — hexagrams, trigrams, changing lines, and reading context from an original English translation. Deterministic lookup only; no casting or divination.

12 days ago

Luxembourg Payments Mcp

12 days ago

12 days ago

MCP Advisor & Installation - Use the right MCP server for your needs

TypeScript

a year ago

Framelink Figma MCP Server

@GLips

MCP server to provide Figma layout information to AI coding agents like Cursor

TypeScript

a year ago

12 days ago

Persistent Adaptive Planning Intelligence - structured loop engineering for AI coding assistants, with memory that persists across sessions, tools, and teammates.

12 days ago

Saudi Arabia Payments Mcp

@junter1989k-ai

12 days ago