MCP Server Demo - ClienteDB

MCP Server Demo - ClienteDB

amauryeuzebio

Developer Tools
Visit Server

README

MCP Server Demo - ClienteDB

Este é um exemplo de servidor MCP que demonstra a integração com SQLite para gerenciamento de clientes.

Funcionalidades

O servidor oferece as seguintes ferramentas:

  1. contar_clientes(): Retorna o número total de clientes cadastrados
  2. buscar_cliente_por_nome(nome): Busca clientes pelo nome (busca parcial)
  3. buscar_clientes_por_bairro(bairro): Busca todos os clientes de um determinado bairro

Como usar

  1. Crie e ative o ambiente virtual:
# Criar ambiente virtual
python3 -m venv .venv

# Ativar ambiente virtual
# No Windows:
.venv\Scripts\activate
# No macOS/Linux:
source .venv/bin/activate
  1. Instale as dependências:
pip install -r requirements.txt # instalar no ambiente virtual

python3.12 -m pip install -r requirements.txt --break-system-packages  # Instalar máquina física
  1. Gere os dados de exemplo:
python generate_sample_data.py
  1. Inicie o servidor MCP:
mcp dev server.py # para usar mcp inspector
mcp install server.py --name "ClientesMCP" # instala o mcp no claude desktop

python mcp_server.py # para usar pelo protocolo sse

Para desativar o ambiente virtual quando terminar:

deactivate

Estrutura do Banco de Dados

A tabela clientes contém os seguintes campos:

  • id (INTEGER, PRIMARY KEY)
  • nome (TEXT)
  • email (TEXT)
  • telefone (TEXT)
  • bairro (TEXT)
  • endereco (TEXT)

Bairros Disponíveis

Os dados de exemplo incluem clientes nos seguintes bairros:

  • Centro
  • Jardim América
  • Vila Nova
  • Bela Vista

Recommended Servers

playwright-mcp

playwright-mcp

A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.

Official
Featured
TypeScript
Magic Component Platform (MCP)

Magic Component Platform (MCP)

An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.

Official
Featured
Local
TypeScript
MCP Package Docs Server

MCP Package Docs Server

Facilitates LLMs to efficiently access and fetch structured documentation for packages in Go, Python, and NPM, enhancing software development with multi-language support and performance optimization.

Featured
Local
TypeScript
Claude Code MCP

Claude Code MCP

An implementation of Claude Code as a Model Context Protocol server that enables using Claude's software engineering capabilities (code generation, editing, reviewing, and file operations) through the standardized MCP interface.

Featured
Local
JavaScript
@kazuph/mcp-taskmanager

@kazuph/mcp-taskmanager

Model Context Protocol server for Task Management. This allows Claude Desktop (or any MCP client) to manage and execute tasks in a queue-based system.

Featured
Local
JavaScript
Linear MCP Server

Linear MCP Server

Enables interaction with Linear's API for managing issues, teams, and projects programmatically through the Model Context Protocol.

Featured
JavaScript
mermaid-mcp-server

mermaid-mcp-server

A Model Context Protocol (MCP) server that converts Mermaid diagrams to PNG images.

Featured
JavaScript
Jira-Context-MCP

Jira-Context-MCP

MCP server to provide Jira Tickets information to AI coding agents like Cursor

Featured
TypeScript
Linear MCP Server

Linear MCP Server

A Model Context Protocol server that integrates with Linear's issue tracking system, allowing LLMs to create, update, search, and comment on Linear issues through natural language interactions.

Featured
JavaScript
Sequential Thinking MCP Server

Sequential Thinking MCP Server

This server facilitates structured problem-solving by breaking down complex issues into sequential steps, supporting revisions, and enabling multiple solution paths through full MCP integration.

Featured
Python