MCP Server Demo - ClienteDB

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.