SwiftAlice/db_mcp_server
If you are the rightful owner of db_mcp_server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
DB Analytics MCP is a server that connects to a PostgreSQL database and performs deep web searches to answer questions using both your data and current web information.
DB Analytics MCP
An MCP server that connects to a PostgreSQL database and does deep web search to answer all your questions. This package allows you to connect your own PostgreSQL database and ask questions about your data and compare it with what's going on in world. The system uses both your database and web search to provide insightful answers.
Features
- Natural language Q&A over your own PostgreSQL database
- Web search integration for up-to-date information
- Powered by LangChain, OpenAI, and PostgreSQL
Installation
1. Install via MCP Client
If you are using the MCP client, you can install the Analytics MCP server directly from the MCP client interface. Follow the instructions in the MCP client to add a new server and provide the package name:
pip install employee-analytics-mcp
2. Add to MCP Server via Cursor Settings
If you are using the MCP server and want to add this tool, you can do so via the Cursor settings:
- Open Cursor.
- Go to Settings > Cusor settings -> MCP -> Add new Global MCP Server
- Configure your environment variables for PostgreSQL and API keys as needed.
Usage
After installation and configuration, you can start the MCP server and use the analyse_db
tool to ask any natural language question about your data or the web.
For more details, see the code and docstrings in the package.