Which integrations are available for this server?

Manages environment variables for API keys and database configuration Powers the AI reasoning capabilities using Gemini 1.5 Flash and Pro models for the conversational interface Provides the foundation for connecting to language models and structuring agent interactions Implements the REACT-style reasoning agent framework for processing user queries and determining appropriate actions Enables storage and retrieval of tax alert data with tools for querying, inserting, updating, and deleting records Powers the interactive frontend chat interface that connects to the MCP server

How do I use Tax Alert Chatbot MCP Server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@Tax Alert Chatbot MCP Server Show me recent tax alerts for California" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

📊 Tax Alert Chatbot (MCP-Powered)

An interactive Streamlit-based chatbot that connects to a custom MCP (Model Context Protocol) server. It allows users to query, insert, update, and delete tax alerts stored in a local SQLite database. The app uses LangGraph’s REACT agent framework with Google Gemini models and supports both SSE and STDIO transport modes.

📁 Project Structure

. ├── client.py # Frontend Streamlit Chat UI ├── server.py # MCP tool & Backend FastMCP SQLite server ├── dummy_tax_alerts.db # SQLite database (if present) ├── .env # Environment variables ├──.venv # virtual environment └── README.md # Documentation

Related MCP server: Zendesk MCP Server

🚀 Features

🤖 Conversational interface with Google Gemini 1.5 models
🧠 REACT-style reasoning agent via LangGraph
🛠️ Tool execution via MCP server
📄 Query, insert, update, and delete operations on tax alert data
🔄 Real-time responses using SSE or STDIO

🛠️ Tech Stack

Layer	Tools / Frameworks
Frontend	Streamlit, LangGraph, LangChain
Backend	FastMCP, SQLite
LLM Provider	Google Gemini 1.5 Flash / Pro (via LangChain)
Transport	SSE (Server-Sent Events) or STDIO
Runtime	Python 3.10+, venv, python-dotenv

⚙️ Setup Instructions

1. Clone the Repository

git clone https://github.com/your-repo/tax-alert-chatbot.git cd tax-alert-chatbot

2. Create and Activate Virtual Environment

python -m venv venv source venv/bin/activate # On Windows: venv\Scripts\activate

3. Install Dependencies

pip install -r requirements.txt (Optional: Split into client/requirements.txt and server/requirements.txt if needed.)

4. Configure Environment Variables

Create a .env file in the root folder:

GOOGLE_API_KEY=your_google_api_key ALERTS_DB=dummy_tax_alerts.db

🗃️ SQLite Schema

CREATE TABLE tax_alerts ( id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT, date TEXT, jurisdiction TEXT, topics TEXT, summary TEXT, full_text TEXT, source_url TEXT, tags TEXT, created_at TIMESTAMP, updated_at TIMESTAMP );

🔧 MCP Server Tools

Tool Name	Description
`query(sql)`	Run `SELECT` queries on the `tax_alerts` table
`insert(...)`	Insert a new tax alert into the database
`update(...)`	Update existing tax alerts based on a condition
`delete(...)`	Delete tax alerts using `WHERE` conditions
`schema_info()`	Return schema and column info of the table

▶️ Running the Server

python server.py

or

python server.py --transport stdio

Make sure your .env contains a valid path to dummy_tax_alerts.db.

💬 Running the Client (Chat UI)

streamlit run client.py

It will automatically open streamlit localhost:8501 in your browser.

⚙️ Configuration (via Sidebar) Gemini Model: Choose between gemini-1.5-flash or gemini-1.5-pro

Server Mode: Only single server supported

Server Type: SSE or STDIO

Server URL: Required only for SSE mode

Clear Chat / Show Tool Executions: Debug & reset tools

🧪 Sample Interaction

User Input:

"Show me tax alerts from 2024 in California"

Agent Response (Tool Call):

SELECT * FROM tax_alerts WHERE jurisdiction='California' AND date LIKE '2024%'

🧼 Debugging & Notes MCP server must be running before starting the client.

Full traceback is shown in the client if errors occur.

Ensure correct database path in .env.

This server cannot be installed

-

security - not tested

F

license - not found

-

quality - not tested

How are these scores calculated?

Resources

GitHub Repository

Need Help?

Report Issue

Related Servers

Tax Alert Chatbot MCP Server