广告合作
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 DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

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
广告合作