MCP Server Demo - ClienteDB

Name: MCP Server Demo - ClienteDB
Author: amauryeuzebio

@amauryeuzebio

代码仓库

关于 MCP Server Demo - ClienteDB

暂无概览

#mcp-server #sqlite #client-management

基本信息

分类

其他

运行时

python

传输方式

stdio

发布者

amauryeuzebio

配置

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

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

工具

未检测到工具

工具是从 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

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.

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

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

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K