Wgong Sqlite Mcp Server

ai.smitheryPublished by smithery.aiOfficial publisherv1.16.0Updated Oct 24, 2026

Explore, query, and inspect SQLite databases with ease. List tables, preview results, and view det…

The publisher's own server: 222wcnm Bilistalkermcp

VerifiedStreamable HTTPWeb executableDatabasesData & Analytics

Overview

AI-generated overview

A read-only SQLite explorer that lets an assistant list tables, inspect schemas and run validated SELECT queries against a database file.

What you can do
List all tables in the connected SQLite database by name and get detailed schema information for a table, including column names, types, NULL constraints, defaults and primary keys. Run SELECT queries with validation, parameter binding and row limits, returning results as dictionaries. Access is read-only, so the assistant can explore and preview data without modifying it.
When to use it
Useful when you want an assistant to explore an existing SQLite database file, understand its schema, or answer questions by running read-only queries without giving it write access.
Requirements
A local Python 3.6+ runtime with the fastmcp package, and the SQLITE_DB_PATH environment variable set to the full path of the SQLite database file. The registry entry is a remote Smithery endpoint requiring an Authorization bearer token header.
Before you install
The remote endpoint requires an Authorization bearer token, so treat that credential as a secret. Queries run against whatever database SQLITE_DB_PATH points to, so point it at a copy rather than sensitive production data; the server is documented as read-only but the database contents are exposed to the assistant.

Installation

In SourceWeft

  1. Open Wgong Sqlite Mcp Server in the dashboard and add it to a workspace.
  2. Enable the server for the chats that should use its tools.

Web executable via Streamable HTTP. Remote servers run from the web runtime once configured in a workspace.

Use with an agent

Paste this prompt into Claude Code, Codex, Cursor or another agent — or into SourceWeft chat. The agent reads this server's install guide, shows you its publisher, endpoint and sign-in, and adds it to your client once you agree. Keys never go into a command.

Read https://sourceweft.com/mcp/ai.smithery%2Fwgong-sqlite-mcp-server/install.md and connect the MCP server it describes to my client. Before changing any config, show me its publisher, endpoint and sign-in method and wait for my OK. Never put an API key in a command or in a file I would commit; ask me where it should come from.

Read the install guide the agent follows

Other MCP clients

Add this to your client's mcpServers config.

{
  "mcpServers": {
    "wgong-sqlite": {
      "type": "http",
      "url": "https://server.smithery.ai/@wgong/sqlite-mcp-server/mcp"
    }
  }
}

README

[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:

bash
# Using pippip 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:

bash
git clone https://github.com/hannesrudolph/sqlite-explorer-fastmcp-mcp-server.gitcd 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:

bash
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:
json
{  "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

Source: sqlite-explorer-fastmcp-mcp-server/README.md at commit 9990d92

Tools

0
SourceWeft has not read this server's tools yet.

Version history

1
  1. v1.16.0LatestSep 16, 2026

Score

85% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

  • Reached in the last 30 daysRequired25 pts
  • Auth declaredRequired10 pts
  • Tools listedRequired15 pts

    Answer tools/list without a credential, or ship a package that starts in a sandbox without one.

  • DescriptionRequired15 pts
  • Logo10 pts
  • Documentation15 pts
  • License10 pts

Other Smithery integrations

222wcnm Bilistalkermcp

ai.smitheryOfficial publisher

Bilibili creator analysis server that lets an assistant look up a specific user's profile, videos, dynamics, articles, subtitles, followings and comments.

Streamable HTTPWeb executable
Knowledge & MemoryNot indexed yetOct 24, 2026

Zwldarren Akshare One Mcp

ai.smitheryOfficial publisher

Remote MCP server that gives an assistant read-only access to Chinese stock market data: historical and real-time prices, news, and financial statements.

Streamable HTTPWeb executableAuth
FinanceCredential requiredOct 24, 2026

Zhaoganghao Hellomcp

ai.smitheryOfficial publisher

A small remote MCP server that lets an assistant greet people by name and share background on the origin of 'Hello, World'.

Streamable HTTPWeb executable
Not indexed yetOct 24, 2026

Zeta Chain Cli

ai.smitheryOfficial publisher

A remote MCP server that lets an assistant generate friendly, customizable greetings for any name or audience.

Streamable HTTPWeb executableAuth
Credential requiredOct 24, 2026

Yuna0x0 Hackmd Mcp

ai.smitheryOfficial publisher

An MCP server that connects an assistant to the HackMD API so it can read, create, update and delete HackMD notes and manage teams.

Streamable HTTPWeb executable
Communication & CollaborationNot indexed yetOct 25, 2026