Metadata-Version: 2.5
Name: mcp-win-stdio-excel-db
Version: 0.2.5
Summary: High-Performance Excel & Database Power Pipeline MCP Server: Zero-Context Streaming, Cross-Source Joins, and Diff Auditing.
Author: Mohan Kumar Indala
License-Expression: MIT
Keywords: analytics,database,duckdb,etl,excel,mcp,pipeline,sql,stdio,streaming
Requires-Python: >=3.10
Requires-Dist: mcp-win-stdio>=0.2.5
Requires-Dist: mcp>=1.2.0
Requires-Dist: openpyxl>=3.1.0
Requires-Dist: pandas>=2.0.0
Requires-Dist: sqlalchemy>=2.0.0
Description-Content-Type: text/markdown

# mcp-win-stdio-excel-db

High-Performance Power Pipeline MCP Server combining SQL Databases and Excel Spreadsheets.

## Features
* **Direct DB to Excel Streaming (`db_to_excel_stream`)**: Zero-context LLM token cost for massive queries.
* **Bulk Excel to DB Upsert (`excel_to_db_upsert`)**: Stream spreadsheets directly into database tables with type inference and chunking.
* **Cross-Source Join Engine (`query_unified_sources`)**: Run unified SQL joining SQL DB tables and `.xlsx` sheets in memory.
* **Reconciliation Auditor (`reconcile_db_vs_excel`)**: Identify data drift and discrepancies between database records and spreadsheets.
* **Template Populator (`db_to_excel_template`)**: Inject database query results into styled corporate Excel workbooks.
