MCP.so
ログイン

MCP Server Demo - ClienteDB

@amauryeuzebio

MCP Server Demo - ClienteDB について

概要はまだありません

基本情報

カテゴリ

その他

ランタイム

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.

コメント

「その他」の他のコンテンツ