Falcon Data Studio is one application with two hosts. The desktop app runs the whole backend on your machine and keeps your connections in a local file. The web app talks to a hosted API and adds user accounts.
Desktop: download the Windows installer from the Download page and run it. Setup installs the .NET 10 runtime and WebView2 when they are missing and starts the app.
Web: open run.falcon-data.studio. You can browse the public connections straight away; Sign in to save connections of your own, or choose "Continue without signing in".
Updates: the desktop toolbar shows "Update to <version>" when a release is out. Click it, then "Restart to update".
The SQL editor is Monaco, loaded from a CDN. The desktop app needs an internet connection for that one component.
Connect to a database
On the welcome page choose Connect (or the SQL Connections icon in the Data Explorer header).
Pick the connection type: Microsoft SQL Server, PostgreSQL or Sybase ASE.
Enter the server as host or host:port, the database, and the credentials. On SQL Server an empty user name means Windows authentication; "Microsoft Entra MFA" signs in through your browser (desktop app only).
Encrypt and Trust Server Certificate are under the connection properties; the Connection String tab shows the result.
Test, then Connect. The connection is saved and appears in the explorer. The name is generated from the database or server until you type one.
Desktop: connections are saved in connections.json under your local application data (FalconSoft, DataStudio). Passwords are protected with Windows DPAPI.
Web: your connections are saved on the server for your account. A connection marked public, with read access, is visible to everyone; passwords never leave the server.
"Edit Connection" on a connection in the explorer changes it in place; "Remove" only hides it from the explorer.
Run SQL scripts
Choose New SQL Script on the welcome page, or open a procedure, function or view from the explorer.
Write the script. Completion offers the tables, columns, procedures and functions of the connection and the SQL keywords of its dialect.
Separate batches with GO. Run the script: the batches execute one after another on the same connection, SSMS-style; a failing batch is reported and the next one still runs.
Each result set opens in its own grid. The Messages pane lists PRINT and RAISERROR output, rows-affected counts and errors with the script line.
SQL
SELECT TOP (50) *
FROM Sales.Orders
WHERE OrderDate >= '2026-01-01'
ORDER BY OrderDate DESC;
GO
PRINT 'Done';
GO
Two batches. The grid shows the first; the Messages pane shows the PRINT.
Edit data in the grid
Open a table from the explorer. Click a cell to edit it; changed cells are tracked until you save.
Add a row with the toolbar, delete selected rows, or paste rows copied from a spreadsheet with Ctrl+V ("Paste as New Rows" from the context menu adds them instead of overwriting).
Use the column filters, sorting and the Column Finder (the search icon in the status bar) to find what you need; filters run on the server.
Save writes the tracked changes in one statement. Export, from the context menu, writes the grid as CSV, TSV or JSON.
Import a CSV file
Import Data streams a file of any size into a table: a plain CSV, a .gz archive or an entry of a .zip. Nothing is held in memory; the first 5,000 rows are sampled for the mapping and the preview.
Choose "Import Data…" on a connection, on its Tables folder or on a table.
Source: pick the file and its settings, then an existing table or a new one. On SQL Server a new table can get a clustered columnstore index.
Map & Transform: check the suggested column matches and the detected types; add transforms per column (Trim, Upper case, Lower case, Date, Number, Boolean, Replace, Default value, Null if, Expression).
Preview & Validate: review the mapped sample and every validation problem before anything is written.
Import: choose Merge, Append or Bulk insert and run. A failed batch pauses with Retry, Skip batch or Stop; rejected rows download as a CSV shaped like the source, with the reasons counted per field.
Open File (welcome page, the tab bar menu or Ctrl+O) loads a CSV, TSV or JSON file into a tab instead; Save to Database then writes it to a table with the same mapping and transforms.
Chart a result
Click the bar-chart icon in the status bar of any grid.
Choose the chart type (line, area, column, bar, pie or scatter), the x field, the value fields and the aggregation; the preview updates as you go. A value field can take its own form and axis for a combo chart.
Plot Chart opens the chart in a floating window that follows the grid: filter, sort or edit and the chart redraws. Settings reopens the configuration; Save as image exports a PNG.
The settings last plotted are remembered for grids with the same columns.
JSPython
JSPython is a Python-like language interpreted in JavaScript. In Falcon Data Studio it runs in two places: as an Expression transform in Import Data and Save to Database, evaluated for every row, and in .jspy script tabs.
JSPython
# Expression transform: value is the cell, row the source row,
# rowNumber and fileName are also available
row.FirstName.trim() + ' ' + row.LastName.trim()
The transform editor previews source and result over the sample while you type.
New JSPython Script on the welcome page opens a .jspy tab. Run it and the Messages panel shows print output, timing and errors with the line.
Scripts are saved in the local workspace next to your SQL scripts and saved queries.
Today scripts have print as their only built-in; data and SQL APIs for scripts are in development.
More documentation
Reference pages are written as the product settles. Planned next:
Keyboard shortcuts Coming soon
Connections reference: every setting per database Coming soon
Import Data reference: formats, transforms and validation rules Coming soon
JSPython reference Coming soon
Table Designer, Indexes/Keys and Relationships Coming soon