Data Warehouse Query Assistant

intermediate

Explore multiple databases, draft safe SQL, and export reviewed analysis artifacts.

Architecture

Database Mcp

Connects to supported SQL databases with controlled access

82/100

npx -y @cocaxcode/database-mcp

MCP Toolbox for Databases

Standardizes database tools across environments

87/100

npx -y @toolbox-sdk/server --prebuilt=postgres

SQLite MCP Server

Validates queries against local extracts

83/100

npx -y @modelcontextprotocol/server-sqlite --db-path ./data.db

Filesystem MCP Server

Stores reviewed SQL and exported summaries

85/100

npx -y @modelcontextprotocol/server-filesystem /path/to/dir

Expected Output

Warehouse Assistant Tables inspected: 7 Query draft: read-only with LIMIT 500 Local extract: validated Output saved: analysis/churn-summary.md -> SQL ready for analyst review

Related Recipes

Market Research Briefing

INTERMEDIATE

Create evidence-backed market briefs from web search, papers, and saved research memory.

researchanalysis

5 components

Data Exploration Toolkit

BEGINNER

Multi-database data exploration with PostgreSQL, MongoDB, and Redis for caching.

data

3 components

Knowledge Management System

BEGINNER

Searchable knowledge base combining Notion content with Elasticsearch-powered search.

dataproductivity

2 components