Skip to main content

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

To install the Query Runner application, follow these steps:
  1. Select the Profile icon and navigate to Settings > Applications.
  2. Click Add Apps and select the Query Runner application. Select Query Runner Application
  3. Click Install.
  4. Set a schedule for the application and click Submit.
The Query Runner application appears in your Installed Applications list and show status as Active
Tip: Installation typically takes a few seconds. If the run fails, check the application logs in Settings > Applications > Query Runner > Logs.

Post-Installation

After tnstallation, SQL Studio appears in the main navigation menu.
Tip: Next Steps: After installation, administrators must configure SQL Studio for supported database services. For detailed setup instructions, see the SQL Studio Admin Configuration.

View Logs

To troubleshoot the issues, you can view the application logs:
  1. Go to Settings > Applications > Query Runner.
  2. Select the Logs tab.
  3. Review recent logs for errors or warnings.
  4. Filter logs by date or severity level.

Uninstall Querry Runner App

If you need to remove SQL Studio:
  1. Go to Settings > Applications > Query Runner.
  2. Select the ⋮ icon and click Uninstall.
  3. Click Ok to remove the appication.

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 to get started.