广告合作
MCP.so
登录

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

常见问题

1

What databases does Database Analyzer MCP Server support?

It only supports PostgreSQL databases.

2

What types of queries can I run?

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

3

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

4

What runtime dependencies are required?

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

5

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

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818
广告合作