Provides database connectivity and operations for managing financial transaction data and other structured data stored in PostgreSQL databases
Designing-an-Agentic-AI-System-with-MCP-Integration
Sample application showing Agentic AI using MCP Server connecting to REST API, PostgreSQL Database and Document Storage
Setup
UV Installation and Setup
- Install UV
To install UV, run the following command: - Verify Installation
Confirm that UV is installed by running:
Using pyproject.toml
Setting Up a Virtual Environment and Installing Dependencies
- Create a Virtual Environment
Run the following command to create a virtual environment: - Activate the Virtual Environment
- On Windows:
- On macOS/Linux:
- On Windows:
- Install Dependencies from
pyproject.toml
Usepip
to install dependencies specified in thepyproject.toml
file: - Verify Installation
Ensure all dependencies are installed correctly: - Run Test Cases
Ensure all test cases are passed using pytest:
Populate Financial Txn Data
- Run the Script to Populate Data
Execute the following command to populate sample financial transaction data:
Configure MCP Client - Claude for Windows
- Locate the Sample Configuration File
Use the providedconfig/sample_claude_desktop_config.json
file as a template. - Copy the Configuration File
Place the file in the following directory: - Rename the File
Rename the file toclaude_desktop_config.json
. - Update Configuration Details
- Open the
claude_desktop_config.json
file in a text editor. - Update the Alpha Vantage API Key with your key.
- Update the Database Connection Details with the appropriate credentials and connection string.
- Open the
Restart Claude Desktop
Restart Claude Desktop, you might have to kill tasks from Task manager. Note that once you restart it,
- You should be able to see number of tools along with hammer icon.
- This will start python program for each tool in background.
This server cannot be installed
remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
Enables integration with financial transaction data through REST APIs, PostgreSQL databases, and document storage systems. Demonstrates agentic AI capabilities by connecting to Alpha Vantage API and managing financial data through natural language interactions.