MCP Server Demo - ClienteDB

@amauryeuzebio

About MCP Server Demo - ClienteDB

No overview available yet

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mcp-server-python-demo": {
      "command": "python3",
      "args": [
        "-m",
        "venv",
        ".venv"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

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.

Frequently asked questions

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.

Comments

Basic information

More Other MCP servers

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

MCP Registry

modelcontextprotocol

A community driven registry service for Model Context Protocol (MCP) servers.

7.0K

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K