Question 1

What is pymcp?

Accepted Answer

pymcp is a Python project based on the FastMCP framework that allows AI agents to interact with MySQL databases. It provides a server-client architecture for querying, analyzing, and leveraging data.

Question 2

What is MCP?

Accepted Answer

MCP stands for Model Context Protocol. It's an open protocol that standardizes how applications provide context to Large Language Models (LLMs), enabling AI models to access external data sources and tools.

Question 3

What are the system requirements for pymcp?

Accepted Answer

pymcp requires Python 3.13 or higher. You also need to install the necessary dependencies using `pip install -r requirements.txt`.

Question 4

How do I install pymcp?

Accepted Answer

You can install pymcp by cloning the repository and running `pip install -r requirements.txt` in your terminal.

Question 5

How do I run the pymcp server?

Accepted Answer

Navigate to the project directory in your terminal and run `python main.py`. The server will start on `0.0.0.0:8080` by default.

Question 6

How do I run the pymcp client?

Accepted Answer

In a separate terminal, navigate to the project directory and run `python client.py`. The client will connect to the server and allow you to execute commands.

Question 7

How do I configure the MySQL connection settings?

Accepted Answer

You can configure the MySQL connection settings in the `src/env.py` (for local environment) or `src/env_dev.py` (for development environment) files. You can set environment variables like `APP_ENV` to switch between environments.

Question 8

What tools are available in pymcp?

Accepted Answer

The server provides tools like `describe_tools` (to list available tools) and `query_mysql(sql: str)` (to execute SQL queries).

Question 9

How do I execute a SQL query using pymcp?

Accepted Answer

Use the `query_mysql` tool with the SQL query as a string. For example: `query_mysql("SELECT * FROM users LIMIT 10;")`.

Question 10

Can I use pymcp with the UBOS platform?

Accepted Answer

Yes, pymcp can be integrated with UBOS to provide AI agents with access to MySQL databases. UBOS offers tools for orchestrating AI agents and connecting them to enterprise data.

Question 11

How do I set the environment (local/development)?

Accepted Answer

You can set the environment using the `APP_ENV` environment variable. For example, `export APP_ENV=dev` sets the environment to development.

Question 12

What if I encounter issues during installation or execution?

Accepted Answer

Refer to the project's README.md for detailed instructions and troubleshooting tips. You can also consult the pymcp documentation for further assistance.

pymcp MySQL Integration Server

Resources

Project Details

Recomended MCP Servers

Featured Templates

Service ERP

Image to text with Claude 3

Speech to Text

Sarcastic AI Chat Bot

Customer Relationship Management (CRM)

Your Speaking Avatar

Start your free trial