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

Install UV
To install UV, run the following command:
```
pip install uv
```
Verify Installation
Confirm that UV is installed by running:
```
uv --version
```

Create a Virtual Environment
Run the following command to create a virtual environment:
```
python -m venv venv
```
Activate the Virtual Environment
- On Windows:
```
venv\Scripts\activate
```
- On macOS/Linux:
```
source venv/bin/activate
```
Install Dependencies from pyproject.toml
Use pip to install dependencies specified in the pyproject.toml file:
```
pip install .
```
Verify Installation
Ensure all dependencies are installed correctly:
```
pip list
```
Run Test Cases
Ensure all test cases are passed using pytest:
```
pytest
```

Run the Script to Populate Data
Execute the following command to populate sample financial transaction data:
```
python util/populate_data.py
```

Locate the Sample Configuration File
Use the provided config/sample_claude_desktop_config.json file as a template.
Copy the Configuration File
Place the file in the following directory:
```
~\AppData\Roaming\Claude
```
Rename the File
Rename the file to claude_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.

Restart Claude Desktop, you might have to kill tasks from Task manager. Note that once you restart it,

Sample application showing Agentic AI using MCP Server connecting to REST API, PostgreSQL Database and Document Storage

Install UV
To install UV, run the following command:
```
pip install uv
```
Verify Installation
Confirm that UV is installed by running:
```
uv --version
```

Create a Virtual Environment
Run the following command to create a virtual environment:
```
python -m venv venv
```
Activate the Virtual Environment
- On Windows:
```
venv\Scripts\activate
```
- On macOS/Linux:
```
source venv/bin/activate
```
Install Dependencies from pyproject.toml
Use pip to install dependencies specified in the pyproject.toml file:
```
pip install .
```
Verify Installation
Ensure all dependencies are installed correctly:
```
pip list
```
Run Test Cases
Ensure all test cases are passed using pytest:
```
pytest
```

Run the Script to Populate Data
Execute the following command to populate sample financial transaction data:
```
python util/populate_data.py
```

Locate the Sample Configuration File
Use the provided config/sample_claude_desktop_config.json file as a template.
Copy the Configuration File
Place the file in the following directory:
```
~\AppData\Roaming\Claude
```
Rename the File
Rename the file to claude_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.

Restart Claude Desktop, you might have to kill tasks from Task manager. Note that once you restart it,