AdoMcp
Let agents explore database schemas and comments and run read-only SQL, with opt-in writes
- Pricing
- Open source
- Platforms
- CLI, self-hosted
- Runs
- Locally
- Version
- 1.5.0
- Listing updated
- today
Similar MCP servers
About AdoMcp
AdoMcp is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.
AdoMcp is a database server built on ADO.NET that lets an agent understand a database before touching it. It finds tables, views, procedures, functions, triggers, sequences and synonyms, reads columns with types, nullability, keys, defaults and the comments people wrote on them, and lists indexes. SQL Server, MySQL and MariaDB, PostgreSQL, SQLite and Oracle are supported.
Safety is deliberate. Reads go through a tool that accepts a single SELECT or WITH query and returns CSV, using a conservative lexical filter that blocks writes, DDL, procedure calls, SELECT INTO and multi-statement batches. The README concedes this is not a full SQL parser and cannot see side effects inside database functions. A separate write tool is disabled by default and enabled per connection or globally at startup, and the server's instructions tell the client to use it only with explicit authorisation.
Connections come from a config file, environment variables or User Secrets, or the agent can add one for the session. It runs over stdio or HTTP, needs .NET 10, and ships as a NuGet package and plugin for Codex, Claude Code and GitHub Copilot.
Install
Run in a terminal
claude mcp add adomcp -- dnx adomcp --yesAdd to claude_desktop_config.json
{
"mcpServers": {
"adomcp": {
"command": "dnx",
"args": [
"adomcp",
"--yes"
]
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"adomcp": {
"command": "dnx",
"args": [
"adomcp",
"--yes"
]
}
}
}Add to .vscode/mcp.json
{
"servers": {
"adomcp": {
"type": "stdio",
"command": "dnx",
"args": [
"adomcp",
"--yes"
]
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"adomcp": {
"command": "dnx",
"args": [
"adomcp",
"--yes"
]
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"adomcp": {
"command": "dnx",
"args": [
"adomcp",
"--yes"
]
}
}
}Using several servers? Build one config file with the MCP config generator.
Tools this server provides (8)
Taken from the project documentation; the running server may differ.
- list_connections
- List configured database connections
- add_connection
- Add or replace a connection in the current process
- remove_connection
- Remove a runtime connection
- list_objects
- Find tables, views, procedures, functions and other objects
- get_table_schema
- Columns, types, keys, defaults and comments
- get_table_indexes
- A table's indexes
- query_sql
- Run read-only SQL and return CSV
- execute_sql
- Run write SQL when enabled
What it does
- Schema discovery
- Find tables, views, procedures, triggers, sequences and synonyms.
- Comments included
- Reads table and column descriptions where the database supports them.
- Index inspection
- Lists a table's indexes.
- Read-only query guard
- Allows only single SELECT or WITH statements and returns CSV.
- Opt-in writes
- The write tool is off unless enabled.
- Five databases
- Works with SQL Server, MySQL, MariaDB, PostgreSQL, SQLite and Oracle.
Good for
- Let an agent learn an unfamiliar schema before writing queries
- Check indexes while tuning a slow query
- Run safe read-only analysis on a development database
- Resolve Oracle synonyms to real schemas
Pricing
Open source
MIT licence
AdoMcp FAQ
Can it modify my data?
Only if you enable the write option, which is off by default.
What do I need to run it?
The .NET 10 SDK; dnx -y AdoMcp fetches it from NuGet.
Which databases work?
SQL Server, MySQL, MariaDB, PostgreSQL, SQLite and Oracle.
Is the read guard perfect?
No, the README says it is a conservative lexical filter and cannot see side effects inside functions.
Is AdoMcp free?
Yes. AdoMcp is open source, so you can use and self-host it for free.
How do I add AdoMcp to Claude Code?
Run this command in your terminal: claude mcp add adomcp -- dnx adomcp --yes
What are the best alternatives to AdoMcp?
The closest alternatives to AdoMcp are REA, Context7, Chrome DevTools MCP, Codebase Memory and GitHub.
Where this comes from
- Description: written from the project's README.
- Install steps: from the official MCP Registry entry.


