Intro

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.

Visualize any SQL Query

With ChartSQL, any valid SQL script is a ChartSQL visualization

-- @chart: column
-- @title: Column - Sales by Month
-- @subtitle: An example column chart showing sales by month
-- @formats: currency
SELECT 
	TRUNC(date_closed, 'MONTH') as Month,
	sum(amount) as Sales
FROM sales
GROUP BY TRUNC(date_closed, 'MONTH')
ORDER BY TRUNC(date_closed, 'MONTH') ASC

See all Available Charts

Key Features

• What you Query is what You Chart: We call it "Whikee-Whic" - Convert SQL queries to charts directly with no additional data shaping.

• Auto-Detection: ChartSQL determines the optimal chart type for your data.

• Flexible @directives: Complete control with @directives to fine-tune chart rendering for complex visual requirements.

• Collaborative: Maintain SQL source code and visualization instructions together in one file.

• Embedding: Add visualizations to applications with dynamic, auto-updating charts that are easily maintained.

Get Started with ChartSQL Studio

ChartSQL Studio is a desktop source code editor to create and execute SQL scripts, charts and visualizations using the ChartSQL language.

ChartSQL Studio Desktop Editor

See Installation Instructions

Visualizations

ChartSQL supports many chart and visualizations:

• Column
• Bar
• Pie
• Line
• Scatter
• Bubble
• Heatmap
• Combo Chart
• Stacked Charts
• Area
• Gauge
• Radar

Practical Uses

From rapidly prototyping dashboards to delivering in-depth reports, ChartSQL serves a broad range of scenarios. See use cases on how developers, data teams and agencies use ChartSQL to visualize data.

For SQL Developers

For Application Developers

For Agencies

For Data Science Teams

Ways to use ChartSQL

• ChartSQL Studio: Desktop SQL and chart editor (Available Now) for designing and presenting visualizations.
• ChartSQL Cloud: Online editor and chart dashboards (In Development)

• ChartSQL.js: Client side rendering for embedding in web applications (In Development)

ChartSQL Studio

ChartSQL Studio is a free editor for creating SQL charts. You can write and execute SQL queries, customize chart settings, and preview the results. With ChartSQL Studio, you have full control over your data and SQL source code.

ChartSQL Studio screenshot

ChartSQL Cloud (coming soon)

Host your ChartSQL scripts With ChartSQL Cloud. Our hosted editor and dashboard tools allow for professional collaboration.

• Automatic Dashboard Sync: When your SQL source updates, so does any dashboard using your charts.

• Multi-Tenant Functionality: Easily clone and customize dashboards across different clients and datasets without changing any code or manually rebuilding.

• Chart Library: Empower teams to create personalized dashboards that stay up to date with your source code. You write the available visualizations in SQL, but they can choose charts from your package libraries to customize their dashboards.

ChartSQL .js

ChartSQL JS is a front-end library that enables you to render SQL-based charts (or table like data) seamlessly within any web application. Quickly add visualizations using ChartSQL embedded directives.

See ChartSQL.js