DB Connect

소개

DB Connect is a multi-database Model Context Protocol (MCP) server designed for exploratory data analysis. It offers secure, read-only access to PostgreSQL, MySQL, and ClickHouse databases, enabling users to explore database structures, analyze data, and execute custom SQL queries safely. With features like comprehensive schema and table listings, detailed column profiling, and robust safety mechanisms, it facilitates in-depth insights into your data across various relational and analytical database systems.

주요 기능

• Comprehensive Database Exploration (schemas, tables, relationships)
• Advanced Data Analysis (column profiling, data sampling, custom queries)
• Secure SSH Tunnel Support for remote database access
• Multi-Database Support (PostgreSQL, MySQL, ClickHouse)
• 10 GitHub stars
• Robust Safety Features (read-only enforcement, query validation, auto-limits)

사용 사례

• Securely accessing and querying databases located behind firewalls via integrated SSH tunnels.
• Performing exploratory data analysis across multiple database types (PostgreSQL, MySQL, ClickHouse).
• Understanding database structure, relationships, and profiling column data for data quality and insights.