> ## Documentation Index
> Fetch the complete documentation index at: https://docs.synehq.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Supported Data Sources

> Connect to 20+ databases and analytics platforms

<Info>
  SyneHQ supports **20+ data sources** through native connectors and protocols, enabling you to query across your entire data ecosystem without complex ETL processes. Our enterprise-grade connectors provide reliable, secure, and high-performance connectivity.
</Info>

<video autoPlay muted controls src="https://video.twimg.com/amplify_video/1948481519955152896/vid/avc1/1920x1080/1F0ezjwbjytCB_EM.mp4" />

## Universal Data Connectivity

<AccordionGroup>
  <Accordion title="SQL Databases">
    ### PostgreSQL Family

    * **PostgreSQL** (versions 9.6+)
    * **Neon** (serverless PostgreSQL)
    * **Supabase** (PostgreSQL with real-time features)
    * **AWS RDS PostgreSQL**
    * **Google Cloud SQL PostgreSQL**
    * **Azure Database for PostgreSQL**

    ### MySQL Family

    * **MySQL** (versions 5.7+)
    * **MariaDB** (MySQL-compatible)
    * **PlanetScale** (serverless MySQL)
    * **AWS RDS MySQL**
    * **Google Cloud SQL MySQL**
    * **Azure Database for MySQL**

    ### Enterprise Databases

    * **Microsoft SQL Server** (2016+)
    * **Oracle Database** (12c+)
    * **Oracle Cloud Autonomous Database**
    * **IBM Db2** (via SQL connector)

    ### Cloud Data Warehouses

    * **Amazon Redshift**
    * **Snowflake** (via SQL connector)
    * **Google BigQuery** (via SQL connector)
    * **Azure Synapse Analytics**
    * **Databricks SQL**

    ### Analytics Databases

    * **ClickHouse** (including ClickHouse Cloud)
    * **Apache Druid**
    * **Apache Pinot**
  </Accordion>

  <Accordion title="NoSQL & Document Databases">
    ### MongoDB

    * **MongoDB Atlas** (cloud-hosted)
    * **Self-hosted MongoDB** (4.0+)
    * **MongoDB with SQL Bridge**: Query MongoDB using SQL syntax
    * **Native Mongosh Support**: Use MongoDB's native query language

    ### Document Stores

    * **CouchDB**
    * **RethinkDB** (via SQL connector)
  </Accordion>

  <Accordion title="Analytics & Event Platforms">
    ### Web Analytics

    * **Google Analytics 4** (via GA4 API)
    * **Mixpanel** (event analytics)
    * **PostHog** (product analytics)

    ### Business Intelligence

    * **Tableau** (via data connector)
    * **Power BI** (via data connector)
    * **Looker** (via data connector)
  </Accordion>

  <Accordion title="Local & Private Deployments">
    ### Self-Hosted Databases

    * **Local PostgreSQL/MySQL instances**
    * **Docker containerized databases**
    * **Kubernetes cluster databases**
    * **On-premise enterprise databases**

    ### Secure Connections

    * **SSH Tunneling**: Connect to databases behind firewalls
    * **VPN Integration**: Secure network connections
    * **Rabbit CLI Tunnel**: Secure tunnel client for local connections
    * **Reverse Proxy**: Custom proxy configurations
  </Accordion>
</AccordionGroup>

## Connection Methods

<AccordionGroup>
  <Accordion title="Direct Connections">
    ```
    Database Type: PostgreSQL
    Host: your-db.example.com
    Port: 5432
    Database: analytics
    Username: synehq_user
    Password: [encrypted]
    ```
  </Accordion>

  <Accordion title="Connection String Format">
    ```
    postgresql://username:password@host:port/database
    mysql://username:password@host:port/database
    mongodb://username:password@host:port/database
    ```
  </Accordion>
</AccordionGroup>

## Connection Security

<AccordionGroup>
  <Accordion title="Authentication Methods">
    * **Username/Password**: Traditional database authentication
    * **SSL/TLS**: Encrypted connections
    * **SSH Keys**: Key-based authentication
    * **OAuth**: Cloud provider authentication
    * **Service Accounts**: Cloud platform service accounts
  </Accordion>

  <Accordion title="Security Features">
    * **Connection Encryption**: All connections encrypted in transit
    * **Credential Management**: Secure credential storage
    * **Connection Pooling**: Efficient resource management
    * **Query Logging**: Audit trail for all queries
  </Accordion>
</AccordionGroup>

## Performance Considerations

<AccordionGroup>
  <Accordion title="Connection Limits">
    * **Maximum Connections**: Configurable per database
    * **Connection Timeout**: Automatic timeout handling
    * **Retry Logic**: Automatic connection retry
    * **Load Balancing**: Multiple connection support
  </Accordion>

  <Accordion title="Query Optimization">
    * **Query Analysis**: Automatic performance profiling
    * **Index Recommendations**: Database optimization guidance
    * **Connection Monitoring**: Real-time connection health
    * **Resource Management**: Efficient resource utilization
  </Accordion>
</AccordionGroup>

## Getting Started

<Info>
  Ready to connect your first data source? Follow these steps to get up and running quickly.
</Info>

<AccordionGroup>
  <Accordion title="Quick Connection Setup">
    1. **Choose your database type** from the supported list
    2. **Gather connection details** (host, port, credentials)
    3. **Test the connection** using SyneHQ's connection tester
    4. **Configure permissions** for the SyneHQ user
    5. **Start querying** with natural language
  </Accordion>

  <Accordion title="Connection Troubleshooting">
    * **Network Issues**: Check firewall and network connectivity
    * **Authentication**: Verify credentials and permissions
    * **SSL/TLS**: Ensure proper certificate configuration
    * **Performance**: Monitor connection pool and query performance
  </Accordion>
</AccordionGroup>

<Card title="Connection Guide" icon="plug" href="/connections">
  Step-by-step connection instructions for each database type
</Card>

<CardGroup cols={2}>
  <Card title="Security Best Practices" icon="shield" href="/security/connections">
    Secure your database connections properly
  </Card>

  <Card title="Performance Tuning" icon="speed" href="/performance/connections">
    Optimize connection performance for your workload
  </Card>
</CardGroup>

## Enterprise Support

<Info>
  For enterprise customers, we offer custom connectors and professional services to ensure seamless integration with your data infrastructure.
</Info>

<AccordionGroup>
  <Accordion title="Custom Connectors">
    For enterprise customers, we can build custom connectors for proprietary or specialized databases. Our engineering team works directly with you to ensure seamless integration.
  </Accordion>

  <Accordion title="Database Not Listed?">
    If your database isn't in our supported list, we can often add support quickly. Contact our enterprise team with your database details for custom development.
  </Accordion>

  <Accordion title="Professional Services">
    * **Database Migration**: Assistance with data source setup
    * **Performance Optimization**: Database tuning and optimization
    * **Security Audits**: Connection security reviews
    * **Training**: Team training on data connectivity
  </Accordion>
</AccordionGroup>

<Card title="Contact Enterprise Sales" icon="message" href="/enterprise">
  Get help with database connections and enterprise features
</Card>