🔥 wsqlite-mcp
Transform your AI Agents into expert WSQLite Architects.
wsqlite-mcp is a professional Model Context Protocol (MCP) server that bridges the gap between AI Agents (Claude, Gemini, OpenCode) and WSQLite. It empowers agents to search, design, and deploy high-performance SQLite-backed services following strict industry-standard patterns.
✨ Key Features
- 🔍 Expert Pattern Catalog: Query production-ready patterns across all WSQLite features (CRUD, Async, Batch, Transactions, Relationships, Query Builder, FTS5, Migrations, Pools, Soft Delete, Pagination, Forensic Ghost Audit Log).
- 🏗️ Strict Architecture Enforcement: Guides AI to output clean code using mandatory
config/,models/,repositories/,migrations/, andmain.pyfolder structures. - 📘 Architect's Manual: Built-in expertise for Monolith-to-SQLite refactoring, schema design, connection pooling, and atomicity patterns.
- 💻 Unified CLI: Manage your MCP service with simple commands:
run,start,stop, andconfig. - 🛡️ Privacy First: 100% local execution via
stdioorSSE.
🚀 Quick Start
1. Installation
Clone the repository and run the automated installer, or install via pip:
pip install -e .
2. Integration
Get your agent-specific configuration block and installation commands by running:
wsqlite-mcp config
The CLI will dynamically detect your Python environment and provide exact copy-paste commands for Gemini CLI (e.g. gemini mcp add ...) and JSON blocks for Claude Desktop.
🛠️ CLI Usage
| Command | Description |
|---|---|
wsqlite-mcp run |
Start the server in stdio mode (default for agents). |
wsqlite-mcp start |
Start as an SSE server in the background. |
wsqlite-mcp stop |
Stop the background server. |
wsqlite-mcp config |
Generate and save JSON config to .agents/wsqlite-mcp.json. |
wsqlite-mcp config --print |
Show JSON configuration in stdout (no file creation). |
wsqlite-mcp help |
Show available tools and commands. |
🛠️ MCP Tools
| Tool | Description |
|---|---|
get_wsqlite_architect_blueprints |
Copy-pasteable expert code for models, CRUD, transactions, FTS5, migrations, pools, and more. |
search_wsqlite_pattern |
Search the official/community catalog for production-ready SQLite patterns. |
deploy_wsqlite_scaffolding |
Deploy a professional WSQLite project structure (config/, models/, repositories/, migrations/, main.py). |
get_wsqlite_architect_manual |
Expert manual for building high-performance SQLite-backed systems. |
📂 Project Structure
src/wsqlite_mcp/: Core server logic and tools.src/wsqlite_mcp/catalog.py: Pattern catalog synchronization with local fallbacks.src/wsqlite_mcp/templates.py: Professional boilerplate definitions.examples/: Sample implementations and use cases.
📄 License
MIT License - Crafted with ❤️ by William Rodriguez (wisrovi).
1 maintainer
Metadata
1 maintainer
Release files for wsqlite-mcp 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 | |
|---|---|---|---|---|
| wsqlite_mcp-0.3.0.tar.gz | 25.3 kB | Without provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| wsqlite_mcp-0.3.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 45.9 kB
Release files / wsqlite_mcp-0.3.0.tar.gz
| Download URL | wsqlite_mcp-0.3.0.tar.gz |
|---|---|
| Size | 25.3 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
8469c718b1f3e236b927b1cdf214ab7e91acbe11ecc1e57dd5f33c47f088125b
|
|
BLAKE2b-256 checksum How to use checksums |
f50bcfca932611f9f6b1927084df9a03bcff51e25786b18c98e915ff77ac6fa4
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.13.5
|
Release files / wsqlite_mcp-0.3.0-py3-none-any.whl
| Download URL | wsqlite_mcp-0.3.0-py3-none-any.whl |
|---|---|
| Size | 20.7 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
829b2f7ddf38b08d3d45228c86bdc6bf06973581c208b8e92661daa8bdcec9ab
|
|
BLAKE2b-256 checksum How to use checksums |
f6847406aaf5959514ad560d9bac671f1db666ff3e790ae56eb0390eed24cd14
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.13.5
|
Security for wsqlite-mcp 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.
No provenance found
None of the files in this release were uploaded with provenance metadata.
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.
