Database Schema MCP Server
@Adhikram
关于 Database Schema MCP Server
暂无概览
基本信息
配置
使用下面的配置,将此服务器添加到你的 MCP 客户端。
{
"mcpServers": {
"mcp-server-adhikram": {
"command": "python",
"args": [
"-m",
"venv",
"venv"
]
}
}
}工具
未检测到工具
工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。
概览
What is Database Schema MCP Server?
An MCP server that provides tools to read and expose database schemas from PostgreSQL, MySQL, SQLite, and other databases. Designed for developers using AI assistants such as Claude or Cursor to explore and understand database structure.
How to use Database Schema MCP Server?
Install Python 3.x, set up a virtual environment, and install dependencies via pip install -r requirements.txt. For Windows, also install Node.js and run the mcp-install.ps1 script. Configure the server in .cursor/mcp.json or the Claude desktop config, then use the tools connect_database, list_tables, get_table_schema, and get_database_schema with a database URL or config dictionary.
Key features of Database Schema MCP Server
- Connect to PostgreSQL, MySQL, and SQLite databases
- List all tables in a connected database
- Get detailed schema information for specific tables
- Retrieve complete database schema including views and indexes
- Support for multiple database types
Use cases of Database Schema MCP Server
- Quickly explore and document a database’s structure
- Generate accurate SQL queries based on schema details
- Enable AI assistants to answer questions about database design
- Reverse engineer and analyze legacy database schemas
FAQ from Database Schema MCP Server
What database types are supported?
PostgreSQL, MySQL, and SQLite are explicitly listed as supported types.
Do I need to install Node.js?
Yes, for Windows MCP installation the README directs you to install Node.js and run the mcp-install.ps1 script.
How do I connect to a database?
Use the connect_database tool with a config dictionary (including type, host, port, database, username, password) or a connection string URL.
Where should I store database credentials?
The README advises using environment variables or secure configuration management and never exposing sensitive credentials in client-side code.
What tools are available?
The server provides four tools: connect_database, list_tables, get_table_schema, and get_database_schema.
数据库 分类下的更多 MCP 服务器
Dbhub
bytebaseZero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.
MCP Alchemy
runekaagaardA MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.
Redis
modelcontextprotocolModel Context Protocol Servers
MotherDuck's DuckDB MCP Server
motherduckdbLocal MCP server for DuckDB and MotherDuck
MCP Server for MySQL based on NodeJS
benborlaA Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
评论