About Sqlite MCP
Sqlite MCP is an MCP server published by StacklokLabs in the Data category: a SQLite MCP server.
The repository has 16 stars and 2 forks, with the last commit 4 days ago. Recent commit activity is the strongest signal that reported issues will get attention.
Install
git clone https://github.com/StacklokLabs/sqlite-mcpThis server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.
Tools (4)
describe_tableGet schema information for a specific table
Parameters not published.
execute_queryExecute SELECT queries against the SQLite database
Parameters not published.
execute_statementExecute INSERT, UPDATE, or DELETE statements (only in read-write mode)
Parameters not published.
list_tablesList all tables in the database
Parameters not published.
Ask AI
Ask AI about Sqlite MCP
Powered by Claude · Grounded in docs
Security checks
Static checks derived from the repository 23 hours ago. Heuristics on the source, not an audit.
- ✓README presentThe repository ships documentation.
- ✓License declaredUsable under a stated license.
- ✓Tests presentA test suite exists in the repository.
- ✓Dependencies pinnedA lockfile pins dependency versions.
- ✓No dynamic code executionSource scan found no eval, dynamic Function, or shell execution.
- !Scoped permissionsDoesn't declare a permission scope. Assume it can do anything its process can.
Releases
README
SQLite MCP Server
A Model Context Protocol (MCP) server that provides tools and resources for querying SQLite databases. This server enables LLMs to interact with SQLite databases through a standardized protocol.
Features
- Database Query Tools: Execute SELECT queries and data modification statements
- Schema Resources: Access database schema information and table structures
- SSE Transport: Server-Sent Events transport for real-time communication
- Read-Only Mode: Optional read-only mode for safe database access
- Comprehensive Testing: Full test coverage with testify
- Linting: Code quality ensured with golangci-lint
Tools
The server provides the following MCP tools:
execute_query: Execute SELECT queries against the SQLite databaseexecute_statement: Execute INSERT, UPDATE, or DELETE statements (only in read-write mode)list_tables: List all tables in the databasedescribe_table: Get schema information for a specific table
Resources
The server provides the following MCP resources:
schema://tables: List of all tables in the databaseschema://table/{name}: Schema information for a specific table
Installation
go build -o sqlite-mcp .
Usage
Basic Usage
./sqlite-mcp -db ./path/to/database.db
Command Line Options
./sqlite-mcp [options]
Options:
-addr string
Address to listen on (default ":8080")
-db string
Path to SQLite database file (default "./database.db")
-help
Show help message
-read-write
Whether to allow write operations on the database. When false, the server operates in read-only mode
Environment Variables
MCP_PORT: Port to listen on (overrides -addr flag port)
Development
Prerequisites
- Go 1.21 or later
- SQLite database file
Contributing
- Fork the repository
- Create a feature branch
- Make your changes
- Add tests for new functionality
- Run tests and linting
- Submit a pull request
README fetched from the repository 23 hours ago. The original is authoritative.