SMKRV MCP Studio
SMKRV MCP Studio is a Docker application for visually constructing MCP (Model Context Protocol) servers from your existing databases. Connect your databases, build SQL-backed tools and resources, design prompt templates, and deploy a fully functional MCP server — all from a visual web interface.Key Features
Connection Manager
PostgreSQL, MySQL, ClickHouse, SQLite, Cassandra, Greenplum, Supabase, Snowflake, and BigQuery with encrypted credentials and connection pooling.
Tool Builder
Monaco SQL editor with parameter auto-detection, typed inputs, live preview, and code generation.
Visual Flow Editor
Drag-and-drop canvas for building and managing MCP configurations with template blueprints and batch operations.
One-Click Deploy
Generate and deploy a complete MCP server with real-time log streaming.
Agent MCP Access
37 MCP tools for AI agents (Claude, GPT, Cursor) with temporary tokens and OAuth2 client credentials.
Security
Encryption at rest, TOTP 2FA, Docker network isolation, SSL/TLS with Let’s Encrypt.
Operational Metrics
Per-tool call counts, response times, p95 latency, time-series charts, and queue monitoring.
Change History
Full audit trail for all entity changes with one-click rollback.
Architecture
SMKRV MCP Studio runs as a 5-container Docker application:| Container | Role |
|---|---|
| frontend | Web interface + reverse proxy |
| backend | REST API + metadata storage |
| mcp | Generated MCP server (your tools/resources) |
| agent-mcp | Agent MCP server (37 management tools) |
| redis | Query queues, metrics, agent tokens |