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

# Query Runner Application for SQL Studio

> Install the Query Runner application to enable SQL Studio - execute SQL queries directly against database services from within Collate.

# Query Runner Application

The Query Runner application enables SQL Studio functionality in Collate, allowing users to execute SQL queries directly against configured database services from within the platform. This eliminates the need to switch between different database clients and provides a unified query execution experience.

## Overview

Query Runner powers SQL Studio, Collate's integrated query execution environment. Once installed and configured, users can:

* **Unified Query Interface**: Write, Save & Execute SELECT queries to explore data across multiple database services without switching tools
* **Flexible Authentication**: Support for SSO-based, OAuth, and credential-based authentication methods

## Prerequisites

* **Admin Access**: You must have administrator privileges in Collate

## Installation

### Step 1: Access the App Marketplace

1. Log in to Collate with your administrator account
2. Navigate to **Settings** from the main navigation menu
3. Click on **Applications** card in settings.
4. Click on **Add Apps** button on top right to visit **`Marketplace`**

### Step 2: Find the Query Runner Application

1. In the App Marketplace, browse or search for **"Query Runner"**
2. The Query Runner application enables SQL Studio functionality
3. Click on the **Query Runner** application card to view details

<img noZoom src="https://mintcdn.com/collatedocs/rwgp94CnO_DBWElR/public/images/applications/query_runner/marketspace.png?fit=max&auto=format&n=rwgp94CnO_DBWElR&q=85&s=99a7c82dd18041e67a5bc8b398a2f100" alt="Query Runner in App Marketplace" width="3020" height="1704" data-path="public/images/applications/query_runner/marketspace.png" />

### Step 3: Install the Application

1. Review the application details:
   * **Description**: The Query Runner Application enables users to execute queries against configured database services
2. Click the **Install** button

<img noZoom src="https://mintcdn.com/collatedocs/rwgp94CnO_DBWElR/public/images/applications/query_runner/install_query_runner.png?fit=max&auto=format&n=rwgp94CnO_DBWElR&q=85&s=a43da1b5a4501c598fc75c58ea206635" alt="Install Query Runner Application" width="2564" height="872" data-path="public/images/applications/query_runner/install_query_runner.png" />

3. Click **Schedule** button → Select **On Demand** option

<img noZoom src="https://mintcdn.com/collatedocs/rwgp94CnO_DBWElR/public/images/applications/query_runner/on_demand.png?fit=max&auto=format&n=rwgp94CnO_DBWElR&q=85&s=76f9c5db55f8c3673fc54224b63c8bca" alt="Select On Demand Scheduling" width="1762" height="702" data-path="public/images/applications/query_runner/on_demand.png" />

4. Click **Create** to proceed with installation

### Step 4: Verify Installation

1. After installation completes, you'll see a success message

<img noZoom src="https://mintcdn.com/collatedocs/rwgp94CnO_DBWElR/public/images/applications/query_runner/installation_success.png?fit=max&auto=format&n=rwgp94CnO_DBWElR&q=85&s=335e30a0a84fb6145264b1e5fcc1fe41" alt="Installation Success Message" width="3004" height="1558" data-path="public/images/applications/query_runner/installation_success.png" />

2. The Query Runner application will appear in your **Installed Applications** list
3. The application status should show as **Active**

<Tip>
  Installation typically takes a few seconds. If the installation fails, check the application logs in **Settings** → **Applications** → **Query Runner** → **Logs**.
</Tip>

## Post-Installation

Once the Query Runner application is installed, **SQL Studio** will appear in the main navigation menu for all users

<img noZoom src="https://mintcdn.com/collatedocs/rwgp94CnO_DBWElR/public/images/applications/query_runner/sqlstudio_in_navigation.png?fit=max&auto=format&n=rwgp94CnO_DBWElR&q=85&s=171f96683d2a252d49faccb5abd77f3b" alt="SQL Studio in Navigation" width="482" height="1562" data-path="public/images/applications/query_runner/sqlstudio_in_navigation.png" />

<Tip>
  **Next Steps**: After installation, administrators must configure SQL Studio for supported database services. See the [SQL Studio Admin Configuration](/how-to-guides/sql-studio/admin-configuration) guide for detailed setup instructions.
</Tip>

## Application Management

### Viewing Application Logs

If you need to troubleshoot issues:

1. Go to **Settings** → **Applications** → **Query Runner**
2. Click on the **Logs** tab
3. Review recent logs for errors or warnings
4. Filter logs by date or severity level

### Uninstalling the Application

If you need to remove SQL Studio:

1. Go to **Settings** → **Applications** → **Query Runner**
2. Click the **Uninstall** button
3. Type the application name to confirm
4. Click **Confirm Uninstall**

## Troubleshooting

### Installation Fails

**Problem**: Installation fails with "Application cannot be installed"

**Solutions**:

* Verify you have admin privileges
* Check that your Collate instance meets minimum requirements
* Review application logs for specific error messages
* Contact support if the issue persists

### Application Not Appearing

**Problem**: After installation, SQL Studio doesn't appear in the navigation

**Solutions**:

* Refresh your browser (Cmd/Ctrl + R)
* Clear browser cache and cookies
* Log out and log back in
* Verify the application status is "Active" in Settings → Applications

## Next Steps

After installing the Query Runner application, follow the **[SQL Studio](/how-to-guides/sql-studio)**  to get started.