mcp-sqlite-bun-server

mcp-sqlite-bun-server

3.4

If you are the rightful owner of mcp-sqlite-bun-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through SQLite.

The SQLite MCP Server is designed to facilitate database interactions and business intelligence operations using SQLite. It allows users to execute SQL queries, analyze business data, and generate business insight memos automatically. The server is equipped with tools for reading and writing database queries, creating tables, and appending insights to a dynamic memo resource. It integrates seamlessly with Claude Desktop, providing a user-friendly interface for managing database operations and generating insights.

Features

  • SQL Query Execution: Supports SELECT, INSERT, UPDATE, and DELETE operations.
  • Business Insights: Automatically generates and updates business insight memos.
  • Schema Management: Tools for creating tables and viewing schema information.
  • Integration: Seamless setup and configuration with Claude Desktop.
  • Logging: Detailed logging with timestamps and structured metadata.

Tools

  1. read-query

    Execute SELECT query and return query results

  2. write-query

    Execute an INSERT, UPDATE, or DELETE query to return the number of affected rows

  3. create-table

    Create a new table and return confirmation information

  4. list-tables

    List all table names in the database

  5. describe-table

    View the structure information of the specified table

  6. append-insight

    Add business insights to the memo resource and trigger updates