What can you do with this server?

An MCP server that exposes SQL Server and Snowflake schema metadata to AI coding agents, enabling schema exploration, join path discovery, stored procedure management, and database administration — primarily using a local cache to avoid live queries on every request. Schema & Metadata Exploration * list_sources, list_schemas, list_tables, get_table, get_dialect, list_all_foreign_keys — browse database sources, schemas, tables, columns, FK relationships, and SQL dialect without live queries Join Path Discovery * find_direct_joins — find FK-defined direct joins between two tables * suggest_joins — suggest multi-hop join paths using FK graph and heuristic column matching, ordered by confidence Search * search_tables — search for tables by keyword * search_columns — search for columns by name across a source or within a specific schema Stored Procedure Tools * list_stored_procedures, get_stored_procedure, search_stored_procedures, search_stored_procedure_text — list, inspect, and search procedures by name or body text * get_call_template — generate a ready-to-use SQL EXEC or Python pyodbc call template * export_stored_procedure — write a stored procedure's SQL definition to a file Live (Uncached) Tools * get_live_stored_procedure — directly connect to any SQL Server via Windows auth to fetch a stored procedure's definition and metadata, bypassing the cache Admin & Configuration * add_database — register a new SQL Server or Snowflake source with connection details and optional live connection testing (requires user confirmation before modifying config) * refresh_metadata — re-scan live databases to update the local schema cache (throttled to once per 24 hours; supports forced refresh)

Which integrations are available for this server?

Provides connectivity to Snowflake databases through a SQL Server linked server, enabling schema exploration, table/column metadata retrieval, foreign key discovery, and stored procedure management without executing live queries on every request.

How do I use db-tools-mcp?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@db-tools-mcp list tables in dbo schema" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

db-tools-mcp

by urjeetpatel

Overview Schema Related Servers Score Discussions

Python

Remote

db-tools-mcp

MCP server that exposes SQL Server and Snowflake schema metadata to AI coding agents. It caches table/column/FK information locally and provides tools for searching schemas, finding join paths, and managing database connections — without running live queries on every request. A separate live-lookup tool is available for one-off stored procedure queries against a database directly.

Quick start

1. Install and run with `uvx`

uvx db-tools-mcp

Or install with pip:

pip install db-tools-mcp
db-tools-mcp

Or install locally for development:

git clone https://github.com/urjeetpatel/db-tools-mcp.git
cd db-tools-mcp
uv sync
uv run db-tools-mcp

2. Register with your MCP client

Claude Desktop (claude_desktop_config.json):

{
  "mcpServers": {
    "db-tools": {
      "command": "uvx",
      "args": ["db-tools-mcp"]
    }
  }
}

Claude Code (.mcp.json in your project root):

{
  "mcpServers": {
    "Db_Tools": {
      "command": "uvx",
      "args": ["db-tools-mcp"]
    }
  }
}

3. Add your first database

Use the add_database tool through your MCP client:

add_database(
  name="my_db",
  db_type="sqlserver",
  url="mssql+pyodbc:///?odbc_connect=DRIVER=ODBC Driver 17 for SQL Server;Server=myhost;Database=MyDB;Trusted_Connection=Yes;"
)

Or copy the example config manually:

# Linux / macOS
mkdir -p ~/.config/db-tools
cp config.example.yaml ~/.config/db-tools/config.yaml

# Windows (PowerShell)
New-Item -ItemType Directory -Force -Path "$env:USERPROFILE\.config\db-tools"
Copy-Item config.example.yaml "$env:USERPROFILE\.config\db-tools\config.yaml"

Then edit ~/.config/db-tools/config.yaml with your connection details.

4. Populate the cache

refresh_metadata()          # all sources
refresh_metadata(source="my_db")  # one source

Or from the command line:

uvx db-tools-refresh
db-tools-refresh --source my_db   # if installed locally

Tools

Read tools (safe, use cached data)

Tool	Description
`list_sources()`	List cached database sources
`list_schemas(source)`	List schemas in a source
`list_tables(source, schema)`	List tables in a schema
`get_table(source, schema, table)`	Get columns + FK relationships
`get_dialect(source)`	SQL dialect (`mssql`, `snowflake`)
`list_all_foreign_keys(source, schema)`	All FKs in a schema
`find_direct_joins(source, table_a, table_b)`	FK joins between two tables
`suggest_joins(source, table_a, table_b)`	Multi-hop join path suggestions
`search_tables(source, keyword)`	Search table names
`search_columns(source, column_name)`	Search column names

Stored procedure tools

Tool	Description
`list_stored_procedures(source, schema)`	List stored procedure names in a schema
`get_stored_procedure(source, schema, name)`	Get SP metadata: parameters, dates, and definition
`search_stored_procedures(source, keyword)`	Search SP names (case-insensitive, optional schema filter)
`search_stored_procedure_text(source, keyword)`	Search SP body text for a keyword; returns matching procedures with a one-line excerpt
`get_call_template(source, schema, name, style)`	Generate a SQL or Python call template for an SP
`export_stored_procedure(source, schema, name, output_file)`	Write SP definition (SQL only) to a file; returns resolved path + line count

export_stored_procedure writes the raw SQL definition only — no JSON wrapper. The output_file must be an absolute path to a writable location; writes to system directories, network paths, drive roots, and the db-tools config directory are blocked.

Live (uncached) tools

Tool	Description
`get_live_stored_procedure(servername, database, name, schema=None)`	Connect directly to a SQL Server (Windows auth) and return an SP's definition + metadata, bypassing the metadata cache entirely

Unlike the stored procedure tools above, get_live_stored_procedure does not use source from config — it opens an ad-hoc Trusted_Connection to any servername/database you specify. Useful for one-off lookups against a database that isn't (or isn't yet) registered as a source. If schema is omitted and multiple procedures share the name across schemas, it returns the candidate schemas instead of guessing.

Admin tools (require confirmation)

Tool	Description
`add_database(name, db_type, ...)`	Add a source to config + test connection
`refresh_metadata(source, force)`	Re-scan live databases (throttled to 1/day)

Configuration

Config and cache live in ~/.config/db-tools/ (XDG standard):

~/.config/db-tools/
  config.yaml          # database connections
  metadata_cache/      # cached JSON per source
  .refresh_state.json  # last-refresh timestamps
  server.log           # MCP server logs

Override the location with DB_TOOLS_CONFIG_DIR or XDG_CONFIG_HOME:

DB_TOOLS_CONFIG_DIR=/custom/path db-tools-mcp

Supported source types

SQL Server (direct ODBC):

my_db:
  enabled: true
  url: "mssql+pyodbc:///?odbc_connect=DRIVER=ODBC Driver 17 for SQL Server;Server=host;Database=db;Trusted_Connection=Yes;"
  include_schemas: ["*"]
  exclude_schemas: [INFORMATION_SCHEMA, sys, db_owner, ...]

Snowflake (via SQL Server linked server / OPENQUERY):

my_snowflake:
  enabled: true
  sqlserver_url: "mssql+pyodbc:///?odbc_connect=..."
  linked_server: "SNOWFLAKE"
  database: "MY_SNOWFLAKE_DB"
  include_schemas: ["*"]
  exclude_schemas: [INFORMATION_SCHEMA]

Requirements

Python >= 3.11
ODBC Driver 17 for SQL Server (for SQL Server and Snowflake-via-linked-server connections)
Network access to the target databases

License

MIT

Install Server

license - permissive license

quality

maintenance

How are these scores calculated?

Maintenance

–Maintainers

–Response time

–Release cycle

–Releases (12mo)

Commit activity

Resources

GitHub Repository

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Tools

View all tools

Related MCP Servers

RunContext
Databases Search Developer Tools
Quiet-Victory-Labs
A
license
-
quality
C
maintenance
Enables AI agents to understand and query your database safely by providing a semantic layer of metadata, with tools to search, explain, validate, and generate safe SQL.
Updated 2 months ago (2026-05-30 23:16 UTC)
2
MIT
io.github.Optisol-Business/dbofficial
Databases Developer Tools
Optisol-Business
A
license
-
quality
D
maintenance
Enables extraction and querying of database schema metadata from PostgreSQL, Snowflake, SQL Server, BigQuery, and Oracle databases, saving results locally for analysis.
Updated 4 months ago (2026-04-16 07:24 UTC)
MIT
snowflake-mcp
Databases Cloud Platforms
faressoft
A
license
A
quality
D
maintenance
Enables AI agents to execute SQL queries and explore Snowflake databases using natural language, with schema discovery, table inspection, and readonly mode.
Updated 5 months ago (2026-03-04 00:20 UTC)
11
741
MIT
MCP → Local MSSQL Server
Databases Developer Tools
DikshaDogra25
F
license
-
quality
C
maintenance
Exposes SQL Server stored procedures as tools for LLM clients (Claude Desktop, VS Code, Cursor, etc.) enabling direct database interaction through natural language.
Updated 2 months ago (2026-06-09 12:49 UTC)

View all related MCP servers

Related MCP Connectors

Umtri
Give your AI agent a persistent map of your project's structure, dependencies, and bugs.
mcp
The grounded data layer for any LLM: governed SQL, metrics, lineage and catalog over your data.
Avo
Define, ship & query your analytics tracking from one source of truth, trusted by humans and agents.

View all MCP Connectors

Latest Blog Posts

Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)
By Om-Shree-0709 on July 25, 2026.
mcp
Agent Identity
OAuth 2.1
Your AI Chatbot Just Exposed Your CEO's Salary to an Intern
By Om-Shree-0709 on July 2, 2026.
Agent Identity
MCP Security
OAuth Delegation
Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)
By Om-Shree-0709 on June 30, 2026.
Agentic Ai
Prompt Injection
WebAssembly

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/urjeetpatel/db-tools-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server

db-tools-mcp

Quick start

1. Install and run with uvx

2. Register with your MCP client

3. Add your first database

4. Populate the cache

Tools

Read tools (safe, use cached data)

Stored procedure tools

Live (uncached) tools

Admin tools (require confirmation)

Configuration

Supported source types

Requirements

License

Maintenance

Resources

Looking for Admin?

Tools

Related MCP Servers

RunContext

io.github.Optisol-Business/dbofficial

snowflake-mcp

MCP → Local MSSQL Server

Related MCP Connectors

Latest Blog Posts

MCP directory API

1. Install and run with `uvx`