Provides a Model Context Protocol interface for SQLite database operations including SQL queries, table management, and business insights tracking, with support for in-memory or file-based storage and easy deployment via Docker or Nixpacks.
Unlock the full potential of SQLite MCP Server through LangDB's AI Gateway. Get enterprise-grade security, analytics, and seamless integration with zero configuration.
Free tier available • No credit card required
A Model Context Protocol (MCP) server that provides SQLite database operations through a standardized interface.
# Install dependencies and build npm install npm start
# Build and run with Docker docker build -t sqlite-mcp-server . docker run -d --name sqlite-mcp sqlite-mcp-server
The application can be easily deployed using Nixpacks with platforms like Railway, Coolify, or Render:
# Deploy with Nixpacks nixpacks build . --name sqlite-mcp-server
No additional configuration is needed as the project includes a Dockerfile.
read_query
: Execute SELECT querieswrite_query
: Execute INSERT, UPDATE, or DELETE queriescreate_table
: Create new tableslist_tables
: List all tables in the databasedescribe_table
: View schema information for a tableappend_insight
: Add business insights to the memoTo connect using SSE in n8n:
http://localhost:3000/sse
http://localhost:3000/messages
// Create a table await callTool('create_table', { query: 'CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)' }); // Insert data await callTool('write_query', { query: 'INSERT INTO users (name) VALUES ("John Doe")' }); // Query data const result = await callTool('read_query', { query: 'SELECT * FROM users' });
None required by default. If using file-based storage, modify the database path in src/index.ts
.
git checkout -b feature/amazing-feature
)git commit -m 'Add some amazing feature'
)git push origin feature/amazing-feature
)ISC
Discover shared experiences
Shared threads will appear here, showcasing real-world applications and insights from the community. Check back soon for updates!