Related MCP Server Resources

Explore more AI models, providers, and integration options:

  • Explore AI Models
  • Explore AI Providers
  • Explore MCP Servers
  • LangDB Pricing
  • Documentation
  • AI Industry Blog
  • SQLite MCP Server
  • Perplexity MCP Server
  • Xano MCP Server
  • Xano MCP Server for Smithery
  • CouchDB MCP Server
Back to MCP Servers
SQLite MCP Server

SQLite MCP Server

Public
isaacgounton/sqlite-mcp-server

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.

javascript
0 tools
May 30, 2025
Updated Jun 4, 2025

Supercharge Your AI with SQLite MCP Server

MCP Server

Unlock the full potential of SQLite MCP Server through LangDB's AI Gateway. Get enterprise-grade security, analytics, and seamless integration with zero configuration.

Unified API Access
Complete Tracing
Instant Setup
Get Started Now

Free tier available • No credit card required

Instant Setup
99.9% Uptime
10,000+Monthly Requests

SQLite MCP Server

A Model Context Protocol (MCP) server that provides SQLite database operations through a standardized interface.

Features

  • In-memory SQLite database (configurable for file-based storage)
  • SQL operations (SELECT, INSERT, UPDATE, DELETE)
  • Table management (CREATE, LIST, DESCRIBE)
  • Business insights memo tracking
  • Docker support for easy deployment

Development & Deployment

Local Development

# Install dependencies and build npm install npm start

Docker Deployment

# Build and run with Docker docker build -t sqlite-mcp-server . docker run -d --name sqlite-mcp sqlite-mcp-server

Nixpacks Deployment

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.

Available Tools

  1. read_query: Execute SELECT queries
  2. write_query: Execute INSERT, UPDATE, or DELETE queries
  3. create_table: Create new tables
  4. list_tables: List all tables in the database
  5. describe_table: View schema information for a table
  6. append_insight: Add business insights to the memo

Remote Server Connection

To connect using SSE in n8n:

  1. Add an MCP Client node
  2. Configure SSE connection:
    • SSE URL: http://localhost:3000/sse
    • Messages Post Endpoint: http://localhost:3000/messages
    • No additional headers required

Example Usage

// 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' });

Environment Variables

None required by default. If using file-based storage, modify the database path in src/index.ts.

Contributing

  1. Fork the repository
  2. Create your feature branch (git checkout -b feature/amazing-feature)
  3. Commit your changes (git commit -m 'Add some amazing feature')
  4. Push to the branch (git push origin feature/amazing-feature)
  5. Open a Pull Request

License

ISC

Publicly Shared Threads0

Discover shared experiences

Shared threads will appear here, showcasing real-world applications and insights from the community. Check back soon for updates!

Share your threads to help others
Related MCPs5
  • SQLite MCP Server
    SQLite MCP Server

    A Model Context Protocol server enabling AI models to execute SQL queries, manage SQLite database sc...

    Added May 30, 2025
  • Perplexity MCP Server
    Perplexity MCP Server

    Provides a Python-based Model Context Protocol interface to the Perplexity API, enabling expert prog...

    Added May 30, 2025
  • Xano MCP Server
    Xano MCP Server

    Python-based Model Context Protocol server enabling AI assistants to securely interact with Xano ins...

    Added May 30, 2025
  • Xano MCP Server for Smithery
    Xano MCP Server for Smithery

    Model Context Protocol server enabling seamless integration between Claude AI and Xano databases wit...

    Added May 30, 2025
  • CouchDB MCP Server
    CouchDB MCP Server

    Model Context Protocol server enabling AI assistants to manage CouchDB databases and documents with ...

    9 tools
    Added May 30, 2025