MCP.so
登录

MCP Server Demo - ClienteDB

@amauryeuzebio

基本信息

分类

其他

传输方式

stdio

作者

amauryeuzebio

关于 MCP Server Demo - ClienteDB

暂无概览

MCP Server Demo - ClienteDB 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

MCP Server Demo - ClienteDB 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表,不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

常见问题

1

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).

2

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.

3

Where does the client data live?

Data is stored in a local SQLite database file, generated by running `python generate_sample_data.py`.

4

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.

5

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.

评论

其他 分类下的更多 MCP 服务器