MCP.so
登录

Database Analyzer MCP Server

@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 服务器

mcp-server-duckdb

ktanaka101

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities

177

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

Elasticsearch MCP Server

elastic

685

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

MongoDB Lens

furey

🍃🔎 MongoDB Lens: Full Featured MCP Server for MongoDB Databases

204