sqlite-reader-mcp
Overview
what is sqlite-reader-mcp?
sqlite-reader-mcp is a lightweight MCP server designed for reading SQLite databases, providing users with read-only access to execute SELECT queries, list tables, and describe table schemas.
how to use sqlite-reader-mcp?
To use sqlite-reader-mcp, install it via uv and run the server with the command sqlite-reader-mcp --paths /path/to/your/database.db. You can then interact with it using a FastMCP client.
key features of sqlite-reader-mcp?
- Read-only access to ensure data integrity.
- Secure path handling to restrict database access.
- SQL validation to permit only safe SQL operations.
- Asynchronous operations for non-blocking interactions.
- Row limiting to prevent excessive data retrieval.
use cases of sqlite-reader-mcp?
- Executing SELECT queries on SQLite databases.
- Listing all tables within a database.
- Describing the schema of specific tables.
FAQ from sqlite-reader-mcp?
- Can I modify data using sqlite-reader-mcp?
No, sqlite-reader-mcp is strictly read-only and does not allow data modification commands.
- What SQL commands are supported?
Only SELECT and WITH statements are permitted.
- How do I ensure security when using sqlite-reader-mcp?
The server restricts access to pre-approved paths and validates all SQL queries.
Recommend Servers
TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.
EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.
AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.
Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.
Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code
MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs
Howtocook Mcp基于Anduin2017 / HowToCook （程序员在家做饭指南）的mcp server，帮你推荐菜谱、规划膳食，解决“今天吃什么“的世纪难题；
Based on Anduin2017/HowToCook (Programmer's Guide to Cooking at Home), MCP Server helps you recommend recipes, plan meals, and solve the century old problem of "what to eat today"
Y GuiA web-based graphical interface for AI chat interactions with support for multiple AI models and MCP (Model Context Protocol) servers.
Playwright McpPlaywright MCP server
DeepChatYour AI Partner on Desktop
WindsurfThe new purpose-built IDE to harness magic
ChatWiseThe second fastest AI chatbot™
BlenderBlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.
Tavily Mcp
MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.
Amap Maps高德地图官方 MCP Server
Serper MCP ServerA Serper MCP Server
CursorThe AI Code Editor
Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。
RedisA Model Context Protocol server that provides access to Redis databases. This server enables LLMs to interact with Redis key-value stores through a set of standardized tools.
Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.