Sponsored by Deepsite.site

MCP.so

Amnesic

Created By
SurajKGoyal21 days ago
Persistent semantic memory for SQL databases (Postgres, MySQL, MSSQL, SQLite). Annotate once, remember forever.
# database
# sql
OverviewContentToolsComments
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

ToolDescription
db_list_connectionsList configured connections (no secrets)
db_list_tablesAll known tables with descriptions
db_searchBM25 search over table/column knowledge
db_get_schemaColumn schema merged with saved annotations
db_queryExecute a read-only SELECT
db_annotatePersist semantic annotations (enum meanings, FKs)
db_sync_knowledgeCopy annotations between connections (staging → prod)
db_discover_relationshipsDiscover all FK relationships from the live DB
db_get_relationshipsNavigate the FK graph for JOIN planning

Install

pipx install amnesic
amnesic init        # interactive setup wizard

Server Config

{
  "mcpServers": {
    "amnesic": {
      "command": "amnesic"
    }
  }
}
Recommend Servers
TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.
WindsurfThe new purpose-built IDE to harness magic
BlenderBlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.
Amap Maps高德地图官方 MCP Server
AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.
Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.
Playwright McpPlaywright MCP server
ChatWiseThe second fastest AI chatbot™
Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。
CursorThe AI Code Editor
RedisA 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.
EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.
Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code
Howtocook Mcp基于Anduin2017 / HowToCook （程序员在家做饭指南）的mcp server，帮你推荐菜谱、规划膳食，解决“今天吃什么“的世纪难题； Based on Anduin2017/HowToCook (Programmer's Guide to Cooking at Home), MCP Server helps you recommend recipes, plan meals, and solve the century old problem of "what to eat today"
Y GuiA web-based graphical interface for AI chat interactions with support for multiple AI models and MCP (Model Context Protocol) servers.
Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.
DeepChatYour AI Partner on Desktop
Serper MCP ServerA Serper MCP Server
Tavily Mcp
MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.
MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs