Skip to main content

Add your description here

Project description

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:

  1. Open Cursor.
  2. Go to Settings > Cusor settings -> MCP -> Add new Global MCP Server
  3. 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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

mcp_postgress_server-0.1.0.tar.gz (3.6 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

mcp_postgress_server-0.1.0-py3-none-any.whl (3.9 kB view details)

Uploaded Python 3

File details

Details for the file mcp_postgress_server-0.1.0.tar.gz.

File metadata

  • Download URL: mcp_postgress_server-0.1.0.tar.gz
  • Upload date:
  • Size: 3.6 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.12.8

File hashes

Hashes for mcp_postgress_server-0.1.0.tar.gz
Algorithm Hash digest
SHA256 70371764cbd1677af692688925cdf8f85cdc2678279fae9238cc754fcd248316
MD5 17e7fc897bf9d473534b6bd89b82d639
BLAKE2b-256 a2dbdb982e9ddb8ced0f03567f271818939c646a5bbc9d376ad2f43c7156b2c4

See more details on using hashes here.

File details

Details for the file mcp_postgress_server-0.1.0-py3-none-any.whl.

File metadata

File hashes

Hashes for mcp_postgress_server-0.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 1c1aa13b772bb7f9a1cefd65491fb5b11869d210abfe2ce1315493cef4e6866e
MD5 e1b66b293e1656b49f3697b6b14fdab6
BLAKE2b-256 a00349394b316d7a48737e72bfd97bcba232fd3675e7031c903eca77ee61e558

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page