Overview
What is MCP Server Demo - ClienteDB?
MCP Server Demo - ClienteDB is an example MCP server that demonstrates integration with SQLite for customer management. It provides tools to query a local client database.
How to use MCP Server Demo - ClienteDB?
Create and activate a Python virtual environment, install dependencies with pip install -r requirements.txt, then generate sample data with python generate_sample_data.py. Start the server using mcp dev server.py, mcp install server.py --name "ClientesMCP", or python mcp_server.py for SSE protocol.
Key features of MCP Server Demo - ClienteDB
- Count total registered clients via
contar_clientes() - Search clients by name with partial matching
- Filter clients by neighborhood using
buscar_clientes_por_bairro() - SQLite database with fields: id, nome, email, telefone, bairro, endereco
- Sample data generator with realistic client records
- Supports both MCP Inspector and Claude Desktop installation
Use cases of MCP Server Demo - ClienteDB
- Demonstrate basic MCP tool creation with a real database backend
- Query client counts and find customers by name or neighborhood
- Learn how to structure an MCP server project with Python and SQLite
- Serve as a template for building customer management MCP integrations
FAQ from MCP Server Demo - ClienteDB
What tools does MCP Server Demo - ClienteDB provide?
The server provides three tools: contar_clientes() (returns total client count), buscar_cliente_por_nome(nome) (partial name search), and buscar_clientes_por_bairro(bairro) (clients by neighborhood).
What runtime dependencies are required?
Python 3.12+ and the packages listed in requirements.txt. SQLite is handled via Python’s built-in sqlite3 module.
Where does the client data live?
Data is stored in a local SQLite database file, generated by running python generate_sample_data.py.
How can I start the server for different use cases?
Use mcp dev server.py to open MCP Inspector for testing, mcp install server.py --name "ClientesMCP" to install into Claude Desktop, or python mcp_server.py to run via SSE protocol.
What are the current limitations?
The server only includes three query tools and a single clientes table with sample data for a fixed set of neighborhoods (Centro, Jardim América, Vila Nova, Bela Vista). No authentication or remote database support is provided.
