convez.ai
MCP ServerDados & AnalyticsIntermediário
hannesrudolph

SQLite Explorer MCP Server

hannesrudolph/sqlite-explorer-fastmcp-mcp-server

Acesso seguro a SQLite para LLMs via MCP com validação de queries

Ver no GitHub
InicialPluginScore · de 0 a 100

Servidor MCP que oferece acesso seguro e somente leitura a bancos de dados SQLite através do Model Context Protocol. Construído com FastMCP, permite que LLMs explorem e consultem databases com validação de queries e proteções de segurança integradas.

Instalação

$npx convez-ai hannesrudolph/sqlite-explorer-fastmcp-mcp-server

1 comando no terminal: detecta o formato do repositório (marketplace ou plugin avulso) e instala via Claude Code. Requer Node 18+ e o Claude Code instalado.

Métricas

Estrelas
108
Forks
28
Acompanhando
2
Saúde
28%
Último commit
há 1 ano
Versão
—
Issues abertas
8
Contribuidores
2

Casos de uso

  • Consultar e explorar estrutura de bancos de dados SQLite
  • Integrar análise de dados em aplicações Claude/LLM
  • Investigar schemas e executar SELECT queries de forma segura
  • Documentar estrutura de databases automaticamente

Veredito

MCP server focado e prático para exploração segura de SQLite. Implementação limpa com FastMCP, proteções contra injeção SQL via validação e binding de parâmetros. Ideal para aplicações que precisam de acesso controlado a dados estruturados.

README

A tradução para o português deste README ainda está na fila.

MseeP.ai Security Assessment Badge

SQLite Explorer MCP Server

An MCP server that provides safe, read-only access to SQLite databases through Model Context Protocol (MCP). This server is built with the FastMCP framework, which enables LLMs to explore and query SQLite databases with built-in safety features and query validation.

📋 System Requirements

  • Python 3.6+
  • SQLite database file (path specified via environment variable)

📦 Dependencies

Install all required dependencies:

# Using pip
pip install -r requirements.txt

Required Packages

  • fastmcp: Framework for building Model Context Protocol servers

All dependencies are specified in requirements.txt for easy installation.

📑 Table of Contents

🛠️ MCP Tools

The server exposes the following tools to LLMs:

read_query

Execute a SELECT query on the database with built-in safety validations. Features:

  • Query validation and sanitization
  • Parameter binding support
  • Row limit enforcement
  • Results formatted as dictionaries

list_tables

List all available tables in the database with their names.

describe_table

Get detailed schema information for a specific table, including:

  • Column names and types
  • NULL constraints
  • Default values
  • Primary key information

🚀 Getting Started

Clone the repository:

git clone https://github.com/hannesrudolph/sqlite-explorer-fastmcp-mcp-server.git
cd sqlite-explorer-fastmcp-mcp-server

📦 Installation Options

You can install this MCP server in either Claude Desktop or the Cline VSCode plugin. Choose the option that best suits your needs.

Option 1: Install for Claude Desktop

Install using FastMCP:

fastmcp install sqlite_explorer.py --name "SQLite Explorer" -e SQLITE_DB_PATH=/path/to/db

Replace /path/to/db with the path to your SQLite database file.

Option 2: Install for Cline VSCode Plugin

To use this server with the Cline VSCode plugin:

  1. In VSCode, click the server icon (☰) in the Cline plugin sidebar
  2. Click the "Edit MCP Settings" button (✎)
  3. Add the following configuration to the settings file:
{
  "sqlite-explorer": {
    "command": "uv",
    "args": [
      "run",
      "--with",
      "fastmcp",
      "--with",
      "uvicorn",
      "fastmcp",
      "run",
      "/path/to/repo/sqlite_explorer.py"
    ],
    "env": {
      "SQLITE_DB_PATH": "/path/to/your/database.db"
    }
  }
}

Replace:

  • /path/to/repo with the full path to where you cloned this repository (e.g., /Users/username/Projects/sqlite-explorer-fastmcp-mcp-server)
  • /path/to/your/database.db with the full path to your SQLite database file

🔒 Safety Features

  • Read-only access to SQLite databases
  • Query validation and sanitization
  • Parameter binding for safe query execution
  • Row limit enforcement
  • Progress output suppression for clean JSON responses

📚 Development Documentation

The repository includes documentation files for development:

  • mcp-documentation.txt: Contains comprehensive documentation about the MCP server implementation and FastMCP framework usage.

This documentation serves as context when developing features and can be used with LLMs to assist in development.

⚙️ Environment Variables

The following environment variables must be set:

  • SQLITE_DB_PATH: Full path to the SQLite database file you want to explore
Ver o original no GitHub

Bom para

Relacionados