Database Mcp Server

security MCP Server

Production-ready MCP provider for SQL databases with unified AI agent interface, supporting MySQL, MariaDB, PostgreSQL, and SQLite with secure credential management and comprehensive query tools.

Verified
securitysecuritypostgresqlmysql
4 views1 stars0 forksMIT

Why This Matters

Discovered via github-topic:model-context-protocol and last synced 3mo ago.

Verified
Source
github-topic:model-context-protocol
Stars
1
Last synced
3mo ago
Install
Check source

Install

Install instructions not detected yet

Check the source repository for the latest setup steps.

View source instructions
22
Tools
0
Resources
0
Prompts
Standard I/O
Transport

Available Tools (22)

list-profiles

List all configured database profiles

validate-query

Validate SQL syntax and flag risky patterns before execution

analyze-schema

Optional `schema` parameter

list-databases

List accessible databases for profile

discover-insights

Discover KPIs, trends, anomalies, and distribution patterns in database tables

list-schemas

Discover all accessible schemas

track-schema-changes

Track schema snapshots/history, generate migrations, and detect schema drift

list-tables

Returns schema information for all tables

discover-joins

Discover foreign key relationships and suggest JOINs

Tool

Schema Support

smart-query-builder

Generate SQL from high-level intent

list-tools

List all available MCP tools and descriptions

describe-table

Optional `schema` parameter with auto-detection

sample-data

Optional `schema` parameter

get-search-path

Diagnostic tool for current schema context

federated-query

Execute read-only cross-profile subqueries with optional JOINs, aggregation, and partial-failure metadata

execute-sql

Execute arbitrary SQL queries with read-only enforcement

analyze-data-lineage

Trace FK-based upstream/downstream table dependencies

mcp-info

Show provider version and author

configure-profile

Create, update, delete, or clone database connection profiles

optimize-query

Run EXPLAIN, return plan, findings, and performance estimate

get-tool-help

Return on-demand summary, examples, and common errors for a tool