Skip to main content
Glama
Sign In
enesjakozh

SQLite MCP Server

by direkt
GitHub
Python
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

Integrations

  • Allows to connect to an SQLite database and query log data through the Model Context Protocol (MCP) server

Log Analysis with SQLite MCP Server

This project provides tools to create an SQLite database from compressed log files and interact with it using the Model Context Protocol (MCP) SQLite server.

Install instructions

python3 -m venv venv source venv/bin/activate pip3 install -r requirements.txt

Place log files in the folder as .gz files, then run:

python3 create_log_db.py

MCP SQLite Server

To configure the MCP SQLite server in Cursor-

  • Cursor Settings
  • MCP
  • Add New MCP Server
  • Name SQLlite
  • Set the type to command
  • Put this in the command box
npx -y @smithery/cli@latest run mcp-server-sqlite-npx --config "{\"databasePath\":\"/path/to/thedatbase/logs.db\"}"

Contents

  • create_log_db.py: Script to extract and parse log files into an SQLite database
  • query_logs.py: Script to directly query the SQLite database
  • logs.db: SQLite database containing parsed log data

Database Structure

The database contains the following tables:

logs Table

  • id: Unique identifier for each log entry
  • timestamp: Timestamp of the log entry
  • thread: Thread that generated the log
  • level: Log level (INFO, WARN, ERROR, DEBUG)
  • module: Module that generated the log
  • message: Log message content
  • source_file: Source log file
  • raw_log: Raw log entry

stack_traces Table

  • id: Unique identifier for each stack trace
  • log_id: Reference to the log entry this stack trace belongs to
  • stack_trace: Full stack trace text

parsing_errors Table

  • id: Unique identifier for each parsing error
  • line: The line that couldn't be parsed
  • source_file: Source log file
  • error_message: Error message explaining why parsing failed
  • timestamp: When the parsing error occurred

You can query the database directly using the query_logs.py script:

This server cannot be installed

-
security - not tested
F
license - not found
-
quality - not tested

local-only server

The server can only run on the client's local machine because it depends on local resources.

Enables querying log data stored in SQLite databases through the Model Context Protocol, allowing natural language interactions with log analysis.

  1. Install instructions
    1. MCP SQLite Server
      1. Contents
        1. Database Structure
          1. logs Table
          2. stack_traces Table
          3. parsing_errors Table

        Related Resources

        Related MCP Servers

        • MCP Variance Log

          truaxki
          A
          security
          A
          license
          A
          quality
          Agentic tool that looks for statistical variations in conversation structure and logs unusual events to a SQLite database. Built using the Model Context Protocol (MCP), this system is designed to be used with Claude Desktop or other MCP-compatible clients.
          Last updated -
          8
          3
          Python
          MIT License
          • Apple
          • Linux

        • SQLite MCP Server

          jacksteamdev
          A
          security
          A
          license
          A
          quality
          A Model Context Protocol server that provides database interaction capabilities through SQLite, enabling users to run SQL queries, analyze business data, and automatically generate business insight memos.
          Last updated -
          6
          9
          TypeScript
          MIT License
          • Apple

        • SQLite MCP Server

          santos-404
          -
          security
          A
          license
          -
          quality
          A Model Context Protocol server implementation that enables AI assistants to execute SQL queries and interact with SQLite databases through a structured interface.
          Last updated -
          6
          TypeScript
          MIT License

        • SQLite MCP Server

          isaacgounton
          -
          security
          F
          license
          -
          quality
          A Model Context Protocol server that enables SQL operations (SELECT, INSERT, UPDATE, DELETE) and table management through a standardized interface with SQLite databases.
          Last updated -
          JavaScript

        View all related MCP servers

        Appeared in Searches

        New MCP Servers

        ID: rw4usp6sv6