Database Schema MCP Server

Name: Database Schema MCP Server
Author: Adhikram

@Adhikram

リポジトリ

Database Schema MCP Server について

概要はまだありません

基本情報

カテゴリ

データベース

ランタイム

python

トランスポート

stdio

公開者

Adhikram

設定

以下の設定を使って、このサーバーを 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 Server for MySQL based on NodeJS

benborla

A 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.

1.9K

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

MCP Alchemy

runekaagaard

A 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.

412