--- title: Run your queries from Tiger Console | Tiger Data Docs description: Choose the right tool to manage your data. Tiger Cloud offers Data view, SQL editor, and SQL assistant to better address your needs --- Tiger Cloud is still PostgreSQL under the hood, so your usual [clients and integrations](/docs/integrate/index.md) keep working. Tiger Console layers collaborative SQL notebooks and assistants on top for teams that want a shared workspace. Inside Tiger Console, pick the surface that matches how you like to work: - [Data view](#data-view): a rich experience powered by PopSQL. You can write queries with autocomplete, save them in folders, share them, create charts/dashboards, and much more. - [SQL assistant in Data view](#sql-assistant): write, fix, and organize SQL faster and more accurately. - [SQL editor](#sql-editor): a simple SQL editor that lets you run ad-hoc ephemeral queries. This is useful for quick one-off tasks like creating an index on a small table or inspecting `pg_stat_statements`. If you prefer the command line to Tiger Console editors, use [psql](/docs/integrate/query-administration/psql/index.md). ## Data view You use Data view in Tiger Console to write queries, visualize data, and share your results. ![Tiger Console Data mode](/docs/_astro/tiger-console-data-mode.CVB-yl27_1J98c8.webp) To start using Data view, open Tiger Console and toggle `Data view`. This includes the following tabs: - **Files**: browse all your personal and shared queries, dashboards, notebooks, and folders. - **Schemas**: view the schemas in your service. - **dbt**: [create dbt macros and models](https://popsql.com/dbt). - **SQL assistant**: [write, fix, and organize SQL](#sql-assistant) faster and more accurately using AI. Available features are: - **Real-time collaboration**: work with your team directly in Data view with live presence and multiple cursors. - **[Schema browser](https://docs.popsql.com/docs/schema)**: understand the structure of your service and see usage data on tables and columns. - **Autocomplete**: get suggestions as you type your queries. - **[Version history](https://docs.popsql.com/docs/version-history)**: access previous versions of a query from the built-in revision history, or connect to a git repo. - **[Charts](https://docs.popsql.com/docs/creating-charts)**: visualize data from inside the UI rather than switch to Sheets or Excel. - **[Schedules](https://docs.popsql.com/docs/scheduled-queries)**: automatically refresh queries and dashboards to create push alerts. - **[Query variables](https://docs.popsql.com/docs/query-variables)**: use Liquid to parameterize your queries or use `if` statements. - **Cross-platform support**: work from [Tiger Console](https://console.cloud.tigerdata.com/dashboard/services?popsql) or download the [desktop app](https://popsql.com/download) for macOS, Windows, and Linux. - **Easy connection**: connect to Tiger Cloud, PostgreSQL, Redshift, Snowflake, BigQuery, MySQL, SQL Server, [and more](https://popsql.com/connections). To connect to a service in Data view: 1. **Check your service is running correctly** In [Tiger Console](https://console.cloud.tigerdata.com/dashboard/services), check that your service is marked as `Running`: ![Tiger Console services list showing a running service](/docs/_astro/tiger-console-services-view.F-zo-hID_1rY9dD.webp) 2. **Connect to your service** Toggle [Data view](https://console.cloud.tigerdata.com/dashboard/services?popsql) in Tiger Console, then select a service in the connection drop-down: ![Select a connection in Tiger Console Data mode](/docs/_astro/tiger-console-data-mode-connection-dropdown.eS_sjlnj_1J2XiX.webp) 3. **Run a test query** Type `SELECT CURRENT_DATE;` in `Scratchpad` and click `Run`: ![Running a query in the Tiger Console scratchpad](/docs/_astro/run-query-in-scratchpad-tiger-console.vyOwaN5N_2mPV5t.webp) Quick recap. You: - Manage your services in [Ops view](https://console.cloud.tigerdata.com/dashboard/services) - Manage your data in [Data view](https://console.cloud.tigerdata.com/dashboard/services?popsql) - Store configuration and security information in your config file. Now you have used Data view in Tiger Console, see how to easily do the following: - [Write a query](https://docs.popsql.com/docs/writing-a-query) - [Share a query with your teammates](https://docs.popsql.com/docs/sharing-a-link-to-your-query-and-results) - [Create a chart from your data](https://docs.popsql.com/docs/creating-charts) - [Create a dashboard of multiple query results](https://docs.popsql.com/docs/creating-dashboards) - [Create schedules for your queries](https://docs.popsql.com/docs/scheduled-queries) ### SQL assistant SQL assistant in [Data view](https://console.cloud.tigerdata.com/dashboard/services?popsql) is a chat-like interface that harnesses the power of AI to help you write, fix, and organize SQL faster and more accurately. Ask SQL assistant to change existing queries, write new ones from scratch, debug error messages, optimize for query performance, add comments, improve readability, and really, get answers to any questions you can think of. ![Tiger Cloud SQL assistant generating a query](/docs/_astro/sql-assistant-in-action.Deu872qV_Z15AwGH.webp) #### Key capabilities SQL assistant offers a range of features to improve your SQL workflow, including: - **Real-time help**: SQL assistant provides in-context help for writing and understanding SQL. Use it to: - **Understand functions**: need to know how functions like `LAG()` or `ROW_NUMBER()` work? SQL assistant explains it with examples. - **Interpret complex queries**: SQL assistant breaks down dense queries, giving you a clear view of each part. - **Error resolution**: SQL assistant diagnoses errors as they happen, you can resolve issues without leaving your editor. Features include: - **Error debugging**: if your query fails, SQL assistant identifies the issue and suggests a fix. - **Performance tuning**: for slow queries, SQL assistant provides optimization suggestions to improve performance immediately. - **Query organization**: to keep your query library organized, and help your team understand the purpose of each query, SQL assistant automatically adds titles and summaries to your queries. - **Agent mode**: to get results with minimal involvement from you, SQL assistant autopilots through complex tasks and troubleshoots its own problems. No need to go step by step, analyze errors, and try out solutions. Simply turn on the agent mode in the LLM picker and watch SQL assistant do all the work for you. Recommended for use when your database connection is configured with read-only credentials. #### Supported LLMs SQL assistant supports a large number of LLMs, including: - GPT-4o mini - GPT-4o - GPT-4.1 nano - GPT-4.1 mini - GPT-4.1 - o4-mini (low) - o4-mini - o4-mini (high) - o3 (low) - o3 - o3 (high) - Claude 3.5 Haiku - Claud 3.7 Sonnet - Claud 3.7 Sonnet (extended thinking) - Llama 3.3 70B Versatile - Llama 3.3 70B Instruct - Llama 3.1 405B Instruct - Llama 4 Scout - Llama 4 Maverick - DeepSeek R1 Distill - Llama 3.3. 70B - DeepSeek R1 - Gemini 2.0 Flash - Sonnet 4 - Sonnet 4 (extended thinking) - Opus 4 - Opus 4 (extended thinking) Choose the LLM based on the particular task at hand. For simpler tasks, try the smaller and faster models like Gemini Flash, Haiku, or o4-mini. For more complex tasks, try the larger reasoning models like Claude Sonnet, Gemini Pro, or o3. We provide a description of each model to help you decide. #### Limitations to keep in mind For best results with SQL assistant: - **Schema awareness**: SQL assistant references schema data but may need extra context in complex environments. Specify tables, columns, or joins as needed. - **Business logic**: SQL assistant does not inherently know specific business terms such as active user. Define these terms clearly to improve results. #### Security, privacy, and data usage Security and privacy is prioritized in Tiger Console. In [Data view](https://console.cloud.tigerdata.com/dashboard/services?popsql), project members manage SQL assistant settings under [`Preferences` > `SQL Assistant`](https://console.cloud.tigerdata.com/dashboard/settings?popsql=%2Fpreferences%2Fai). ![SQL assistant settings in Tiger Console](/docs/_astro/tiger-console-sql-editor-preferences.kZe_coOz_JWTJf.webp) SQL assistant settings are: - **Opt-in features**: all AI features are off by default. Only [members](/docs/deploy/tiger-cloud/tiger-cloud-aws/security/members/index.md) of your Tiger Cloud project can enable them. - **Data protection**: your data remains private as SQL assistant operates with strict security protocols. To provide AI support, Tiger Console may share your currently open SQL document, some basic metadata about your database, and portions of your database schema. By default, Tiger Console **does not include** any data from query results, but you can opt in to include this context to improve the results. - **Sample data**: to give the LLM more context so you have better SQL suggestions, enable sample data sharing in the SQL assistant preferences. - **Telemetry**: to improve SQL assistant, Tiger Data collects telemetry and usage data, including prompts, responses, and query metadata. ### Data view FAQ #### What if my service is within a VPC? If your Tiger Cloud service runs inside a VPC, do one of the following to enable access for the PopSQL desktop app: - Use PopSQL‘s [bridge connector](https://docs.popsql.com/docs/bridge-connector). - Use an SSH tunnel: when you configure the connection in PopSQL, under `Advanced Options` enable `Connect over SSH`. - Add PopSQL‘s static IPs (`23.20.131.72, 54.211.234.135`) to your allowlist. #### What happens if another member of my Tiger Cloud project uses Data view? The number of Data view seats you are allocated depends on your [pricing plan](https://www.tigerdata.com/pricing#features). #### Will using Data view affect the performance of my Tiger Cloud service? There are a few factors to consider: 1. What instance size is your service? 2. How many users are running queries? 3. How computationally intensive are the queries? If you have a small number of users running performant SQL queries against a service with sufficient resources, then there should be no degradation to performance. However, if you have a large number of users running queries, or if the queries are computationally expensive, best practice is to create a [read replica](/docs/deploy/tiger-cloud/tiger-cloud-aws/high-availability/read-scaling/index.md) and send analytical queries there. If you’d like to prevent write operations such as insert or update, instead of using the `tsdbadmin` user, create a read-only user for your service and use that in Data view. ## SQL editor SQL editor is an integrated secure UI that you use to run queries and see the results for a Tiger Cloud service. ![SQL editor in Tiger Console Ops mode](/docs/_astro/tiger-console-ops-mode-sql-editor.ruC--u4y_ZQqjK7.webp) To enable or disable SQL editor in your service, click `Operations` > `Service management`, then update the setting for SQL editor. To use SQL editor: 1. **Open SQL editor from Tiger Console** In Tiger Console, select a service, then click `SQL Editor` at the bottom. ![SQL editor in Tiger Console Ops mode](/docs/_astro/tiger-console-ops-mode-sql-editor-empty.D6fPmf48_LfDRl.webp) 2. **Run a test query** Type `SELECT CURRENT_DATE;` in the UI and click `Run`. The results appear in the lower window: ![Running a query in the Tiger Console Ops mode SQL editor](/docs/_astro/run-a-query-in-tiger-ops-mode-sql-editor.BDO4ugTF_Z1vhVMu.webp) ## Cloud SQL editor licenses - **SQL editor**: free for anyone with a [Tiger Cloud account](/docs/get-started/quickstart/create-service/index.md). - **Data view**: the number of seats you are allocated depends on your [pricing plan](https://www.tigerdata.com/pricing#features). [SQL assistant](#sql-assistant) is currently free for all users. In the future, limits or paid options may be introduced as we work to build the best experience. - **PopSQL standalone**: there is a free plan available to everyone, as well as paid plans. See [PopSQL Pricing](https://popsql.com/pricing) for full details.