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
- Required argument:
Tools
The server offers six core tools:
Query Tools
read-query: Execute SELECT queries on the databasewrite-query: Execute INSERT, UPDATE, or DELETE queriescreate-table: Create new database tables
Schema Tools
list-tables: Get a list of all tables in the databasedescribe-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)
| 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)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| 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 logRelease 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 logSecurity 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.
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 logA 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.