Which integrations are available for this server?

Supports interaction with the MCP server's REST API endpoints using curl commands for creating and retrieving messages Provides interactive API documentation through Swagger UI, allowing users to explore and test the MCP server's endpoints at http://localhost:8000/docs

How do I use Message Control Protocol (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., "@Message Control Protocol (MCP) Server create a new message with content 'Meeting scheduled for 2 PM' and priority 2" 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.

Python Project

This is a Python project template with a basic structure.

Project Structure

. ├── README.md ├── requirements.txt ├── src/ │ └── main.py └── .gitignore

Related MCP server: Ollama_MCP_Guidance

Setup

Create a virtual environment (recommended):
python -m venv venv source venv/bin/activate # On Windows: venv\Scripts\activate
Install dependencies:
pip install -r requirements.txt

Running the Project

To run the project:

python src/main.py

Development

Add your Python code in the src directory
Add new dependencies to requirements.txt
Update this README as needed

MCP Server with Oracle Database Integration

This is a Message Control Protocol (MCP) server implementation that provides a REST API for message handling with Oracle Database integration using ODBC.

Prerequisites

Python 3.8 or higher
Oracle Client installed and configured
ODBC Driver for Oracle installed

Installation

Clone the repository
Install the required dependencies:

pip install -r requirements.txt

Configure the database connection:
- Update the database settings in config.py
- Make sure your Oracle ODBC driver is properly configured

Database Setup

Create the messages table in your Oracle database:

CREATE TABLE messages ( id NUMBER GENERATED ALWAYS AS IDENTITY PRIMARY KEY, content VARCHAR2(4000) NOT NULL, priority NUMBER DEFAULT 1, metadata VARCHAR2(4000), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );

Running the Server

Start the server with:

python main.py

The server will start on http://localhost:8000 by default.

API Endpoints

POST /messages/ - Create a new message
GET /messages/ - Retrieve all messages
GET /health - Health check endpoint

API Documentation

Once the server is running, you can access the interactive API documentation at:

Swagger UI: http://localhost:8000/docs
ReDoc: http://localhost:8000/redoc

Example Usage

Create a new message:

curl -X POST "http://localhost:8000/messages/" \ -H "Content-Type: application/json" \ -d '{"content": "Test message", "priority": 1, "metadata": {"key": "value"}}'

Get all messages:

curl "http://localhost:8000/messages/"

Error Handling

The server includes comprehensive error handling for:

Database connection issues
Query execution errors
Invalid input data
Server health monitoring

Security Considerations

Update the default configuration in config.py with your secure credentials
Consider implementing authentication and authorization
Use HTTPS in production
Implement rate limiting for production use

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

Message Control Protocol (MCP) Server