HybridHub

# HybridHub Universal Hybrid Data MCP Server - Connect to both structured (databases) and unstructured (object storage) data sources. ## Features - **Structured Data Sources (Databases)** - PostgreSQL - MySQL - MariaDB - SQL Server - SQLite - **Unstructured Data Sources (Object Storage)** - Huawei Cloud OBS - Alibaba Cloud OSS - AWS S3 / S3-Compatible (MinIO, etc.) - Tencent Cloud COS ## Quick Start ### 1. Install Dependencies ```bash npm install # or yarn install # or pnpm install ``` ### 2. Configure Data Sources Copy the sample configuration file: ```bash cp env.sample .env ``` Edit `.env` with your data source credentials. For multi-source configuration, copy and edit the TOML example: ```bash cp hybridhub.toml.example hybridhub.toml ``` ### 3. Run the Server ```bash # Development mode npm run dev # Production mode npm run build npm start ``` ## Configuration ### Environment Variables | Variable | Description | Example | |----------|-------------|---------| | `HYBRIDHUB_TRANSPORT` | Transport mode | `stdio` or `http` | | `HYBRIDHUB_PORT` | HTTP port | `8080` | | `HYBRIDHUB_API_KEY` | API key for authentication | `your-api-key` | #### Database Configuration | Variable | Description | Example | |----------|-------------|---------| | `DSN` | Database connection string | `postgres://user:pass@localhost:5432/db` | | `DB_TYPE` | Database type | `postgres`, `mysql`, `sqlite`, etc. | | `DB_HOST` | Database host | `localhost` | | `DB_PORT` | Database port | `5432` | | `DB_NAME` | Database name | `mydb` | | `DB_USER` | Database username | `user` | | `DB_PASSWORD` | Database password | `password` | | `DB_READONLY` | Enable read-only mode | `true` or `false` | | `DB_MAX_ROWS` | Maximum rows per query | `1000` | #### Storage Configuration | Variable | Description | Example | |----------|-------------|---------| | `STORAGE_TYPE` | Storage provider type | `s3`, `oss`, `obs`, etc. | | `STORAGE_ENDPOINT` | Storage endpoint URL | `https://s3.amazonaws.com` | | `STORAGE_ACCESS_KEY` | Access key ID | `AKIAIOSFODNN7EXAMPLE` | | `STORAGE_SECRET_KEY` | Secret access key | `wJalrXUtnFEMI...` | | `STORAGE_REGION` | Storage region | `us-east-1` | | `STORAGE_PATH_STYLE` | Use path-style URLs (for MinIO) | `true` or `false` | ### TOML Configuration For multi-source configuration, use `hybridhub.toml`: ```toml # Database source [[databases]] id = "prod_pg" dsn = "postgres://user:password@localhost:5432/production" readonly = false max_rows = 1000 # Storage source [[storages]] id = "aws_s3" type = "s3" endpoint = "https://s3.amazonaws.com" access_key = "AKIAIOSFODNN7EXAMPLE" secret_key = "wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY" region = "us-east-1" ``` See `hybridhub.toml.example` for complete configuration options. ## MCP Tools ### Database Tools - `execute_sql` - Execute SQL queries on database sources ### Storage Tools - `list_buckets` - List all storage buckets - `list_objects` - List objects in a bucket - `get_object` - Get object content - `get_object_metadata` - Get object metadata - `search_objects` - Search objects with filters ## Development ```bash # Run in development mode npm run dev # Run with HTTP transport npm run dev:http # Build for production npm run build # Run tests npm test ``` ## License MIT