Mcp Server Python Demo
What is Mcp Server Python Demo
The mcp-server-python-demo is a demonstration server that showcases the integration with SQLite for client management. It serves as an example of how to implement a basic MCP server with functionalities to manage client data.
Use cases
Use cases include managing client databases for small businesses, integrating client management into larger applications, and providing a backend service for client-related operations.
How to use
To use mcp-server-python-demo, first create and activate a virtual environment, then install the required dependencies. Generate sample data and start the MCP server using the provided commands. Finally, deactivate the virtual environment when done.
Key features
Key features include: 1) contar_clientes(): Returns the total number of registered clients; 2) buscar_cliente_por_nome(nome): Searches for clients by name (partial search); 3) buscar_clientes_por_bairro(bairro): Retrieves all clients from a specific neighborhood.
Where to use
mcp-server-python-demo can be used in various fields such as customer relationship management, data management systems, and any application requiring client data handling and retrieval.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Mcp Server Python Demo
The mcp-server-python-demo is a demonstration server that showcases the integration with SQLite for client management. It serves as an example of how to implement a basic MCP server with functionalities to manage client data.
Use cases
Use cases include managing client databases for small businesses, integrating client management into larger applications, and providing a backend service for client-related operations.
How to use
To use mcp-server-python-demo, first create and activate a virtual environment, then install the required dependencies. Generate sample data and start the MCP server using the provided commands. Finally, deactivate the virtual environment when done.
Key features
Key features include: 1) contar_clientes(): Returns the total number of registered clients; 2) buscar_cliente_por_nome(nome): Searches for clients by name (partial search); 3) buscar_clientes_por_bairro(bairro): Retrieves all clients from a specific neighborhood.
Where to use
mcp-server-python-demo can be used in various fields such as customer relationship management, data management systems, and any application requiring client data handling and retrieval.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
MCP Server Demo - ClienteDB
Este é um exemplo de servidor MCP que demonstra a integração com SQLite para gerenciamento de clientes.
Funcionalidades
O servidor oferece as seguintes ferramentas:
contar_clientes(): Retorna o número total de clientes cadastradosbuscar_cliente_por_nome(nome): Busca clientes pelo nome (busca parcial)buscar_clientes_por_bairro(bairro): Busca todos os clientes de um determinado bairro
Como usar
- Crie e ative o ambiente virtual:
# Criar ambiente virtual
python3 -m venv .venv
# Ativar ambiente virtual
# No Windows:
.venv\Scripts\activate
# No macOS/Linux:
source .venv/bin/activate
- Instale as dependências:
pip install -r requirements.txt # instalar no ambiente virtual
python3.12 -m pip install -r requirements.txt --break-system-packages # Instalar máquina física
- Gere os dados de exemplo:
python generate_sample_data.py
- Inicie o servidor MCP:
mcp dev server.py # para usar mcp inspector
mcp install server.py --name "ClientesMCP" # instala o mcp no claude desktop
python mcp_server.py # para usar pelo protocolo sse
Para desativar o ambiente virtual quando terminar:
deactivate
Estrutura do Banco de Dados
A tabela clientes contém os seguintes campos:
- id (INTEGER, PRIMARY KEY)
- nome (TEXT)
- email (TEXT)
- telefone (TEXT)
- bairro (TEXT)
- endereco (TEXT)
Bairros Disponíveis
Os dados de exemplo incluem clientes nos seguintes bairros:
- Centro
- Jardim América
- Vila Nova
- Bela Vista
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
