SQLite Explorer

Overview

SQLite Explorer is an MCP server built with FastMCP that gives AI assistants direct access to SQLite databases for data analysis and inspection. It provides tools for listing tables, describing table structures, and executing SELECT queries, all accessible through the MCP protocol from Claude Desktop, VS Code with Cline, or other MCP-compatible clients.

Key Features

• Three Core Tools — list_tables to see all tables, describe_table to view table structure, and read_query to run SELECT queries on the database
• FastMCP Framework — Built on FastMCP for simple development and deployment, with built-in inspector and web-based testing interface
• Multiple Client Support — Works with Claude Desktop, VS Code with Cline, and Smithery playground, configured via environment variable for the database path
• Interactive Development — Includes fastmcp dev for a web-based testing interface and fastmcp inspect for interactive tool verification during development

Who is this for?

Developers and data analysts who want AI assistants to directly explore and query SQLite databases. It is particularly useful for data analysis workflows where you need to inspect database schemas and run ad-hoc queries through an AI interface without writing code manually.