Database Analyzer MCP Server

@NandaGopal56

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

NandaGopal56

Database Analyzer MCP Server について

概要はまだありません

#database-analyzer#mcp-server #postgresql

Database Analyzer MCP Server の設定

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

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

Database Analyzer MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは 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

よくある質問

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.

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

Elasticsearch MCP Server

elastic

685

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes