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

# Connect SQL and NoSQL Databases to Qvista Instantly

> Connect MySQL, PostgreSQL, MongoDB, Redis, and more to Qvista for real-time data extraction, complex queries, and encrypted transfers.

Qvista connects directly to both relational SQL databases and modern NoSQL data stores, giving you real-time access to structured and semi-structured data without moving or duplicating records. Whether you're running complex analytical queries against a PostgreSQL warehouse or pulling JSON documents from MongoDB, Qvista handles the connection, query execution, and data delivery in a single, unified workflow.

## SQL Databases

Qvista supports the most widely used relational database engines across on-premises and cloud-hosted environments:

<CardGroup cols={2}>
  <Card title="MySQL" icon="database">
    A widely used open-source database ideal for web applications and transactional systems.
  </Card>

  <Card title="PostgreSQL" icon="database">
    An advanced open-source relational database known for its extensibility, performance, and standards compliance.
  </Card>

  <Card title="Microsoft SQL Server" icon="database">
    A reliable, scalable enterprise solution supporting both on-premises and cloud-based SQL Server instances.
  </Card>

  <Card title="Oracle Database" icon="database">
    High-performance database management designed for critical, large-scale business workloads.
  </Card>

  <Card title="SQLite" icon="database">
    A lightweight, self-contained engine well-suited for embedded systems and local development environments.
  </Card>
</CardGroup>

### Key Features for SQL Connections

* **Real-time data extraction and transformation** — fetch the latest records on every query with no stale caches
* **Encrypted data transfer** — all connections use SSL/TLS encryption to protect data in transit
* **Complex query support** — run multi-table joins, stored procedures, views, and parameterized T-SQL or ANSI SQL queries directly from Qvista
* **Change data capture** — track incremental updates in your database so dashboards reflect changes as they happen
* **Automated scheduling** — set extraction jobs to run at defined intervals, keeping downstream reports and dashboards fresh without manual intervention

## NoSQL Databases

Qvista also integrates with leading NoSQL platforms, making it straightforward to work with unstructured and semi-structured data alongside your relational sources:

<CardGroup cols={2}>
  <Card title="MongoDB" icon="leaf">
    A document-based database optimized for high-volume storage and flexible JSON schemas.
  </Card>

  <Card title="Cassandra" icon="server">
    A distributed database designed for high availability, linear scalability, and fault tolerance.
  </Card>

  <Card title="Redis" icon="bolt">
    An in-memory data structure store ideal for caching, real-time analytics, and session management.
  </Card>

  <Card title="Elasticsearch" icon="magnifying-glass">
    A distributed search and analytics engine for fast, scalable full-text search and log analysis.
  </Card>

  <Card title="CouchDB" icon="file-code">
    A schema-free database using a JSON document model, well-suited for dynamic and offline-first applications.
  </Card>
</CardGroup>

### Key Features for NoSQL Connections

* **Native JSON and document support** — query key-value, document, and wide-column data without conversion overhead
* **High-performance handling of distributed datasets** — Qvista is optimized for the large-scale, distributed nature of NoSQL architectures
* **Real-time indexing and search** — leverage Elasticsearch and Redis capabilities for fast, live data retrieval

## Connect a SQL Database

Follow these steps to add a SQL database as a data source in Qvista:

<Steps>
  <Step title="Open Data Sources">
    In the Qvista sidebar, navigate to **Data Sources** and click **Add New Source**.
  </Step>

  <Step title="Select Your Database Type">
    Choose your database engine from the list — for example, **PostgreSQL** or **MySQL** — and click **Configure**.
  </Step>

  <Step title="Enter Connection Details">
    Provide your host address, port number, database name, username, and password. For cloud-hosted instances, paste the full connection string if available.
  </Step>

  <Step title="Configure SSL / TLS Encryption">
    Toggle **Require Encrypted Connection** to enable SSL/TLS. Upload your CA certificate if your database server requires mutual TLS authentication.
  </Step>

  <Step title="Test the Connection">
    Click **Test Connection**. Qvista verifies credentials and network access. A green checkmark confirms a successful connection.
  </Step>

  <Step title="Set Access Controls">
    Assign the connection to one or more workspace roles so only authorized team members can query this source.
  </Step>

  <Step title="Save and Start Querying">
    Click **Save**. Your database now appears in the Data Sources panel and is ready to use in dashboards, reports, and workflows.
  </Step>
</Steps>

<Note>
  All database connections in Qvista use **SSL/TLS encryption** by default. Qvista also supports role-based access controls so you can restrict which users and workspaces have permission to query a given database. For Microsoft SQL Server, parameterized queries are enforced automatically to prevent SQL injection.
</Note>

## Unified Analytics Across SQL and NoSQL

Once connected, you can combine data from multiple database types in a single dashboard or report. Pull structured sales records from PostgreSQL, enrich them with customer events from MongoDB, and surface unified insights — all without writing custom ETL code.

<Tip>
  Use Qvista's built-in **data transformation tools** to clean and reformat data after extraction — for example, standardizing date formats across a MySQL source and a MongoDB collection before merging them in a visualization.
</Tip>