Database Analyzer MCP Server

Name: Database Analyzer MCP Server
Author: NandaGopal56

@NandaGopal56

リポジトリ

Database Analyzer MCP Server について

概要はまだありません

#database-analyzer #mcp-server #postgresql

基本情報

カテゴリ

データベース

ランタイム

python

トランスポート

stdio

公開者

NandaGopal56

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "mcp-server-demo-nandagopal56": {
      "command": "python",
      "args": [
        "server.py"
      ]
    }
  }
}

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is Database Analyzer MCP Server?

A database analysis tool that provides an MCP server interface for PostgreSQL database introspection and analysis. It allows exploring database schemas, relationships, and executing safe SELECT queries through a standardized interface.

How to use Database Analyzer MCP Server?

Clone the repository, install required Python packages, and create a .env file with PostgreSQL credentials. Start the server by running python server.py. The server exposes tools for schema analysis and safe query execution.

Key features of Database Analyzer MCP Server

List all tables in a specified schema
Get detailed schema information for specific tables
View column definitions, data types, and constraints
Execute SELECT queries with parameterized inputs
Built-in security to prevent unauthorized modifications
Environment variable‑based configuration for sensitive data

Use cases of Database Analyzer MCP Server

Explore a PostgreSQL database schema without direct database access
Retrieve table metadata and column details for documentation or migration
Run safe read‑only queries through an AI‑ or tool‑driven interface
Automate database introspection within an MCP‑compatible workflow

FAQ from Database Analyzer MCP Server

What databases does Database Analyzer MCP Server support?

It only supports PostgreSQL databases.

What types of queries can I run?

Only SELECT queries are allowed; INSERT, UPDATE, DELETE, and other modification queries are blocked for security.

How do I configure database credentials?

Credentials are read from a .env file in the project root with the variables POSTGRES_HOST, POSTGRES_PORT, POSTGRES_DB, POSTGRES_USER, and POSTGRES_PASSWORD.

What runtime dependencies are required?

Python 3.x and the packages mcp, psycopg2, and python-dotenv are required.

Does Database Analyzer MCP Server store any data?

No, it only connects to an existing PostgreSQL database and does not persist data itself.

「データベース」の他のコンテンツ

MCP MongoDB Server

kiliczsh

A Model Context Protocol Server for MongoDB

281

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