# ChartSQL ## ChartSQL - [Intro](https://docs.chartsql.com/basics/readme.md): ChartSQL is a visualization language embedded in SQL scripts. ChartSQL is designed for data scientists, SQL developers, and web application developers to quickly visualize complex queries. - [Quick Start](https://docs.chartsql.com/basics/quick-start.md): Brief overview of ChartSQL features and uses - [Overview](https://docs.chartsql.com/charts/example-charts.md): Browse full example charts to get inspirations for your visualizations - [Auto Charts](https://docs.chartsql.com/charts/auto-charts.md): Fully auto detected charts based on the available columns in the result set - [Area](https://docs.chartsql.com/charts/area.md): Example area charts - [Bar](https://docs.chartsql.com/charts/bar.md): Example Bar Charts - [Bubble](https://docs.chartsql.com/charts/bubble.md): Bubble charts show the relationship between three numerical variables - [Column](https://docs.chartsql.com/charts/column.md): Column charts show numerical values across categories - [Combo](https://docs.chartsql.com/charts/combo.md): Combine multiple types of charts into a single chart - [Gauge](https://docs.chartsql.com/charts/gauge.md): Gauge Chart Examples - [Heatmap](https://docs.chartsql.com/charts/heatmap.md): Heatmaps show the strength of a value compared to others across two dimensions - [Line](https://docs.chartsql.com/charts/line.md): Line charts show how different numerical values compare, typically across time - [Pie](https://docs.chartsql.com/charts/pie.md): Pie charts show the relative contribution of values in relationship to the whole - [Radar](https://docs.chartsql.com/charts/radar.md): Radar Chart Examples - [Scatter](https://docs.chartsql.com/charts/scatter.md): Scatter charts show the relationship between two numerical variables - [Formatting & Rendering](https://docs.chartsql.com/charts/formatting-and-rendering.md): Examples of charts with changed formatting, rendering and additional options - [Baselines](https://docs.chartsql.com/charts/formatting-and-rendering/baselines.md): Horizontal marks added to charts to mark major comparative values of a series like the average, median, min or max. - [Formats](https://docs.chartsql.com/charts/formatting-and-rendering/formats.md): Example charts with customized formats - [Series Titles](https://docs.chartsql.com/charts/formatting-and-rendering/series-titles.md): Example charts controlling series titles - [Series Labels](https://docs.chartsql.com/charts/formatting-and-rendering/series-labels.md): Charts with series labels applied - [Stacked Charts](https://docs.chartsql.com/charts/formatting-and-rendering/stacked-charts.md): Examples of charts using stacking - [Grouped Category](https://docs.chartsql.com/charts/formatting-and-rendering/grouped-category.md): Examples of charts with Grouped Categories - [Overview](https://docs.chartsql.com/chartsql-studio/overview.md): ChartSQL Studio is a source code editor to create and execute SQL scripts, charts and visualizations - [ChartSQL Studio Cloud](https://docs.chartsql.com/chartsql-studio/chartsql-studio-cloud.md): ChartSQL Studio Cloud is a browser accessible version of the ChartSQL Studio editor that you can access at ChartSQL.com - [Installing Studio Desktop](https://docs.chartsql.com/chartsql-studio/installing-studio-desktop.md): ChartSQL Studio Desktop is a local desktop version of ChartSQL Studio and Studio Server. - [Basic Concepts](https://docs.chartsql.com/chartsql-studio/basic-concepts.md): Basic concepts of ChartSQL that you should know to work effectively with your charts - [Interface Overview](https://docs.chartsql.com/chartsql-studio/basic-concepts/interface-overview.md): Overview of the main ChartSQL Studio interface panels and features - [Workspace](https://docs.chartsql.com/chartsql-studio/basic-concepts/workspace.md): Understanding the ChartSQL Studio Workspace - [SQL Scripts & Charts](https://docs.chartsql.com/chartsql-studio/basic-concepts/sql-scripts-and-charts.md): Explanation of SQL scripts and charts - [Folders](https://docs.chartsql.com/chartsql-studio/basic-concepts/folders.md): A collection of SQL scripts in a folder added to your workspace - [Datasources](https://docs.chartsql.com/chartsql-studio/basic-concepts/datasources.md): SQL, NoSQL and APIs that you wish to query and visualize - [Thinking in ChartSQL](https://docs.chartsql.com/chartsql-studio/basic-concepts/thinking-in-chartsql.md): Tips about creating visualizations with ChartSQL - [Creating Charts](https://docs.chartsql.com/chartsql-studio/creating-charts.md): Key steps and concepts in creating charts and visualizations within ChartSQL - [Editor Panels](https://docs.chartsql.com/chartsql-studio/creating-charts/editor-panels.md): Overview of the ChartSQL Studio Editor Features - [Column Data Types](https://docs.chartsql.com/chartsql-studio/creating-charts/column-data-types.md): Understanding ChartSQL column data types - [Chart Types](https://docs.chartsql.com/chartsql-studio/creating-charts/chart-types.md): Explanation of Chart SQL chart types and visualization modes - [Directives](https://docs.chartsql.com/chartsql-studio/creating-charts/directives.md): Directives allow precise control over all aspects of your visualization - [Stacking](https://docs.chartsql.com/chartsql-studio/creating-charts/stacking.md): Grouping series together to show relationships to part of a whole - [Baselines](https://docs.chartsql.com/chartsql-studio/creating-charts/baselines.md): Horizontal marks added to charts to mark major comparative values of a series like the average, median, min or max. - [Series Titles](https://docs.chartsql.com/chartsql-studio/creating-charts/series-titles.md): Controlling how series are titled - [Dynamic SQL Charts](https://docs.chartsql.com/chartsql-studio/creating-charts/dynamic-sql-charts.md): Creating dynamic SQL charts from user input - [Dynamic Data Functions](https://docs.chartsql.com/chartsql-studio/creating-charts/dynamic-data-functions.md): Complex excel like formulas for recursive and external data - [Presenting](https://docs.chartsql.com/chartsql-studio/presenting.md): Presentation mode hides most of the features of the editor and makes the charts full screen so that you can present your visualizations to an audience. - [Settings & Customization](https://docs.chartsql.com/chartsql-studio/settings-and-customization.md): Details about all of the settings available to you to customize - [Troubleshooting & Support](https://docs.chartsql.com/chartsql-studio/troubleshooting-and-support.md): Common issues, support & community - [Datasources](https://docs.chartsql.com/chartsql-studio/datasources.md) - [Overview](https://docs.chartsql.com/chartsql-studio/datasources/datasources.md): Data sources that you can query against to produce charts and visualizations - [CSV File](https://docs.chartsql.com/chartsql-studio/datasources/csv-file.md): Local CSV file that you can query against - [HyperSQL](https://docs.chartsql.com/chartsql-studio/datasources/hypersql.md): HyperSQL Datasource Connector Details - [MongoDB](https://docs.chartsql.com/chartsql-studio/datasources/mongodb.md): MongoDB Datasource Connector Details - [MySQL](https://docs.chartsql.com/chartsql-studio/datasources/mysql.md): MySQL Datasource Connector Details - [PostgreSQL](https://docs.chartsql.com/chartsql-studio/datasources/postgresql.md): PostgreSQL Datasource Details - [SQLite](https://docs.chartsql.com/chartsql-studio/datasources/sqlite.md): SQLite Connector Details - [Custom Datasources](https://docs.chartsql.com/chartsql-studio/datasources/custom-datasources.md): Developing Custom Datasources for ChartSQL Studio - [Extensions](https://docs.chartsql.com/chartsql-studio/extensions.md) - [Overview](https://docs.chartsql.com/chartsql-studio/extensions/overview.md): Overview of ChartSQL Extensions - [Extension Points](https://docs.chartsql.com/chartsql-studio/extensions/extension-points.md): Descriptions of the elements in the ChartSQL Studio UI that are user extensible - [Core Extensions](https://docs.chartsql.com/chartsql-studio/extensions/core-extensions.md): Descriptions of the extensions that ship with ChartSQL Studio - [Extensions API Reference](https://docs.chartsql.com/chartsql-studio/extensions/extensions-api-reference.md): API Reference for the ChartSQL Studio Extensions API - [Coming Soon](https://docs.chartsql.com/dashboards/coming-soon.md): Getting started with Dashboards for ChartSQL - [Coming Soon](https://docs.chartsql.com/chartsql-js/coming-soon.md): Embedded SQL based charts in any web application - [Auto Charts](https://docs.chartsql.com/reference/auto-charts.md): Fully auto detected charts based on the available columns in the result set - [Directives](https://docs.chartsql.com/reference/directives.md): Documentation for the ChartSQL language directives - [@baselines](https://docs.chartsql.com/reference/directives/baselines.md): Horizontal marks added to charts to mark major comparative values of a series like the average, median, min or max. - [@baseline-types](https://docs.chartsql.com/reference/directives/baseline-types.md): Determines the type of baseline to use in conjunction with the @baselines directive - [@chart](https://docs.chartsql.com/reference/directives/chart.md): Defines the type of chart like line, area, column, combo - [@category](https://docs.chartsql.com/reference/directives/category.md): Defines the column from the result set that will serve as the primary xAxis category or pie chart category. - [@formats](https://docs.chartsql.com/reference/directives/baselines-1.md): Specify the visual formatting of series data in the chart - [@series](https://docs.chartsql.com/reference/directives/series.md): Comma separated list of columns to use for data on the chart - [@title](https://docs.chartsql.com/reference/directives/title.md): Primary name for your chart that is displayed throughout the UI - [@subtitle](https://docs.chartsql.com/reference/directives/subtitle.md): A short description about the visualization displayed under the title throughout the UI - [@groups](https://docs.chartsql.com/reference/directives/groups.md): Defines a list of hierarchical columns to group along the primary axis - [@series-types](https://docs.chartsql.com/reference/directives/series-types.md): Describes the chart types to apply to individual series when the @chart: combo is defined - [@series-labels](https://docs.chartsql.com/reference/directives/series-labels.md): Adds labels to series items, placing the text at the top, bottom, inside and various positions - [@stacking-mode](https://docs.chartsql.com/reference/directives/stacking-mode.md): Whether the stacking for the chart is shown as 100% of the total or none - [//@directive: comments](https://docs.chartsql.com/reference/directives/directive-comments.md): Commenting out directives during development - [@dash-id](https://docs.chartsql.com/reference/directives/dash-id.md): Globally unique identifier given to a ChartSQL chart that is published to DashSQL.com - [@overlay-series](https://docs.chartsql.com/reference/directives/overlay-series.md): Overlays the specified series on top of each other - [@tags](https://docs.chartsql.com/reference/directives/overlay-series-1.md): Describe your SQL script with searchable tags - [@select-list](https://docs.chartsql.com/reference/directives/select-list.md): Update the SQL query dynamically from a dropdown list in the ChartSQL Studio UI - [Glossary](https://docs.chartsql.com/reference/glossary.md) - [Shortcuts](https://docs.chartsql.com/reference/shortcuts.md) - [Publishing API](https://docs.chartsql.com/reference/publishing-api.md): API description and procedures for publishing charts to ChartSQL.com - [About](https://docs.chartsql.com/product-and-community/about.md): About ChartSQL Development, why we built it and where we're headed. - [Features](https://docs.chartsql.com/product-and-community/features.md): High level overview of ChartSQL features - [Use Cases](https://docs.chartsql.com/product-and-community/use-cases.md): Development scenarios that ChartSQL is well suited for - [General Uses](https://docs.chartsql.com/product-and-community/use-cases/general-uses.md): General benefits and use cases of ChartSQL - [For SQL Developers](https://docs.chartsql.com/product-and-community/use-cases/for-sql-developers.md): ChartSQL is great for SQL developers to quickly add visualizations to your SQL scripts - [For Application Developers](https://docs.chartsql.com/product-and-community/use-cases/for-application-developers.md): ChartSQL is a great addition for Application Developers. You can quickly visualize your data and add charts to your application. - [For Agencies](https://docs.chartsql.com/product-and-community/use-cases/for-agencies.md): ChartSQL is a great addition to a web, software or analytics development agencies - [For Data Science Teams](https://docs.chartsql.com/product-and-community/use-cases/for-data-science-teams.md): How Data Scientists and data teams can use ChartSQL - [Community & Support](https://docs.chartsql.com/product-and-community/community-and-support.md): Reach out to the ChartSQL community or get support from ChartSQL - [Roadmap](https://docs.chartsql.com/product-and-community/roadmap.md): Product roadmap for ChartSQL - [Release Notes](https://docs.chartsql.com/product-and-community/release-notes.md): ChartSQL development release notes - [In Development](https://docs.chartsql.com/product-and-community/in-development.md): Documentation for features that are in development. - [Workspaces](https://docs.chartsql.com/product-and-community/in-development/workspaces.md): Workspaces combine multiple folders and datasources that you can work on together - [Dashboards](https://docs.chartsql.com/product-and-community/in-development/dashboards.md) - [Intro](https://docs.chartsql.com/product-and-community/in-development/dashboards/intro.md): Getting started with Dashboards for ChartSQL - [Dashboards](https://docs.chartsql.com/product-and-community/in-development/dashboards/dashboards.md): Details about creating and managing Dashboards - [Packages](https://docs.chartsql.com/product-and-community/in-development/dashboards/packages.md): A Package is a collection of ChartSQL charts that can be added to the Dashboard - [Pages](https://docs.chartsql.com/product-and-community/in-development/dashboards/pages.md): Organizing charts into pages - [Charts](https://docs.chartsql.com/product-and-community/in-development/dashboards/charts.md): Charts are the ChartSQL Visualizations displayed in your Dashboards - [Access Control](https://docs.chartsql.com/product-and-community/in-development/dashboards/access-control.md): Controlling access to Dashboards and Pages - [Sharing & Publishing](https://docs.chartsql.com/product-and-community/in-development/sharing-and-publishing.md): Sharing and Publishing charts to the external world - [ChartSQL.js](https://docs.chartsql.com/product-and-community/in-development/chartsql.js.md) - [Overview](https://docs.chartsql.com/product-and-community/in-development/chartsql.js/overview.md): Easy JavaScript based charts in any web application - [@threshold](https://docs.chartsql.com/product-and-community/in-development/baselines.md): Sets a target value for a series and highlights the series values that have met the threshold - [Thresholds](https://docs.chartsql.com/product-and-community/in-development/baselines-1.md): Target values added to charts to highlight if a series value has met the target. - [Sheets](https://docs.chartsql.com/product-and-community/in-development/sheets.md): Exploring adding spreadsheet features to ChartSQL Studio for adhoc data exploration --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on a page URL with the `ask` query parameter: ``` GET https://docs.chartsql.com/basics/readme.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.