A simple MCP server to let AI interact with Microsoft Access and SQLite 3 databases. Supports import/export with CSV and Excel files, and store
Access mdb mcp server lets Claude, Cursor and other MCP clients work with Access Mdb directly. A simple MCP server to let AI interact with Microsoft Access and SQLite 3 databases. Supports import/export with CSV and Excel files, and store human-readable notes about files.
A simple MCP server to let AI interact with Microsoft Access and SQLite 3 databases. Supports import/export with CSV and Excel files, and store human-readable notes about files.
Once connected, the assistant can call these 11 tools directly:
list — List all active databases available in the servercreate — Create a new database file (for Microsoft Access, copies the empty.mdb template)connect — Connect to an existing database file, or creates an in-memory database if the file is not specifieddisconnect — Close a database connection. For in-memory databases, this will clear all its dataquery — Execute a SQL query to retrieve data from a databaseupdate — Execute a SQL query to insert/update/delete data in a databaseimport_csv — Imports data from a CSV file into a database tableexport_csv — Exports data from a database table to a CSV fileimport_excel — Imports data from an Excel file into a database tableread_notes — Reads notes from the specified file, or discovers notes in the specified directorywrite_notes — Writes notes to the specified file, or linked to the specified databaseSetup follows the standard MCP pattern: clone or install the server, then register it in your client's configuration file and restart the client. The configuration snippets on this page cover Claude Desktop, Claude Code and Cursor.
Database servers turn schema archaeology and ad-hoc reporting into conversation, which is why they tend to be the second or third server people install. Access Mdb sits in that group, and the shape of its toolset — list, create, connect among others — tells you what it is really for. Worth comparing against the other databases servers in this directory before you commit to one, since several overlap in scope but differ sharply in setup cost and permissions.
| Tool | What it does |
|---|---|
| list | List all active databases available in the server. |
| create | Create a new database file (for Microsoft Access, copies the empty.mdb template). |
| connect | Connect to an existing database file, or creates an in-memory database if the file is not specified. |
| disconnect | Close a database connection. For in-memory databases, this will clear all its data. |
| query | Execute a SQL query to retrieve data from a database. |
| update | Execute a SQL query to insert/update/delete data in a database. |
| import_csv | Imports data from a CSV file into a database table. |
| export_csv | Exports data from a database table to a CSV file. |
| import_excel | Imports data from an Excel file into a database table. |
| read_notes | Reads notes from the specified file, or discovers notes in the specified directory. |
| write_notes | Writes notes to the specified file, or linked to the specified database. |
{
"mcpServers": {
"access-mdb": {
"command": "uv",
"args": [
"run",
"--with", "fastmcp",
"--with", "pandas",
"--with", "sqlalchemy-access",
"--with", "openpyxl",
"fastmcp", "run",
"path/to/repo/server.py"
],
}
}
}Configuration as documented by the project. Restart the client after saving.
Read-only SQL access to Postgres — let your assistant inspect schemas and answer questions from real data.
Manage your whole Supabase project in conversation — database, auth, storage, Edge Functions and branches.
Query, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.
Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.
Official MongoDB server covering data, schemas and Atlas management — from find queries to spinning up clusters.
Serverless Postgres with database branching — point your assistant at Neon and let it work on disposable copies.