Skip to main content
Archived

This project has been archived by its maintainers, and is no longer receiving any updates.

SQLite MCP Server

Overview

A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through SQLite. This server enables running SQL queries, analyzing business data, and automatically generating business insight memos that can be enhanced with Claude's analysis when an Anthropic API key is provided.

Components

Resources

The server exposes a single dynamic resource:

  • memo://insights: A continuously updated business insights memo that aggregates discovered insights during analysis
    • Auto-updates as new insights are discovered via the append-insight tool
    • Optional enhancement through Claude for professional formatting (requires Anthropic API key)

Prompts

The server provides a demonstration prompt:

  • mcp-demo: Interactive prompt that guides users through database operations
    • Required argument: topic - The business domain to analyze
    • Generates appropriate database schemas and sample data
    • Guides users through analysis and insight generation
    • Integrates with the business insights memo

Tools

The server offers six core tools:

Query Tools

  • read-query: Execute SELECT queries on the database
  • write-query: Execute INSERT, UPDATE, or DELETE queries
  • create-table: Create new database tables

Schema Tools

  • list-tables: Get a list of all tables in the database
  • describe-table: View the schema of a specific table

Analysis Tools

  • append-insight: Add new business insights to the memo resource

Installation

# Add the server to your claude_desktop_config.json
"mcpServers": {
  "sqlite": {
    "command": "uv",
    "args": [
      "--directory",
      "parent_of_servers_repo/servers/src/sqlite",
      "run",
      "mcp-server-sqlite",
      "--db-path",
      "~/test.db"
    ]
  }
}

Metadata

Release files for mcp-server-sqlite 0.3.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for mcp-server-sqlite 0.3.0
File Size Uploaded Provenance Actions
mcp_server_sqlite-0.3.0.tar.gz 18.6 kB With provenance Details for mcp_server_sqlite-0.3.0.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for mcp-server-sqlite 0.3.0
File Interpreter ABI Platform Actions
mcp_server_sqlite-0.3.0-py3-none-any.whl Python 3 none any Details for mcp_server_sqlite-0.3.0-py3-none-any.whl

Total release size: 26.9 kB

Release files / mcp_server_sqlite-0.3.0.tar.gz

Download URL mcp_server_sqlite-0.3.0.tar.gz
Size 18.6 kB
Tags Source
SHA-256 checksum
How to use checksums
94e9eda0ab21f726fc3de7216910fdb72a52869d7ae5138b7837ddca2b1c794e
BLAKE2b-256 checksum
How to use checksums
bff33728396733085fbe3b07bfdac0275fe4712c63ea7ed2b07fcaad97cbe200
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/5.1.1 CPython/3.12.7

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Nov 21, 2024.

Transparency log

Release files / mcp_server_sqlite-0.3.0-py3-none-any.whl

Download URL mcp_server_sqlite-0.3.0-py3-none-any.whl
Size 8.3 kB
Tags Python 3
SHA-256 checksum
How to use checksums
c889a021005ee6675c83f6da20896e3a707089fc195fcccac04dd055b918d4b0
BLAKE2b-256 checksum
How to use checksums
fc405ff79260c03c80152749f643cb742f75b654c5d0e2c89c75cea46d30e2b1
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/5.1.1 CPython/3.12.7

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Nov 21, 2024.

Transparency log

Security for mcp-server-sqlite 0.3.0

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

Full provenance

Both files in this release have been uploaded with provenance metadata.

Select from 2 files

Attestation for mcp_server_sqlite-0.3.0.tar.gz

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Nov 21, 2024.

Transparency log

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page