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.1

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.1
File Size Uploaded Provenance Actions
mcp_server_sqlite-0.3.1.tar.gz 18.4 kB With provenance Details for mcp_server_sqlite-0.3.1.tar.gz

Built distribution (wheel)

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

Total release size: 26.6 kB

Release files / mcp_server_sqlite-0.3.1.tar.gz

Download URL mcp_server_sqlite-0.3.1.tar.gz
Size 18.4 kB
Tags Source
SHA-256 checksum
How to use checksums
f3ef3df51acd86231d12682cc65d4facefe7ce62a600c63f681c195a47777039
BLAKE2b-256 checksum
How to use checksums
dde48ab98d1247686b89685726d118d190b0fe7cd5d55d22ebeb91cc0cc10b1c
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.1-py3-none-any.whl

Download URL mcp_server_sqlite-0.3.1-py3-none-any.whl
Size 8.2 kB
Tags Python 3
SHA-256 checksum
How to use checksums
b2ae024e279cbbde358cb6a31dace1e80e486fecca329fa66c377d6726f4acbf
BLAKE2b-256 checksum
How to use checksums
a2fd188460da3ecdcbbf84ca019dd64946e8390e17d98d001b9c68639f32326f
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.1

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

All 2 files in this release have been uploaded with provenance metadata.

Select from 2 files

Attestation for mcp_server_sqlite-0.3.1.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