Table Designer
Create and alter tables with typed columns and a primary key, then save: the differences are applied for you.
Database IDE
Database Management, Reimagined.
Write SQL, navigate database objects, explore schemas and edit data with a fast, familiar development experience.
Falcon Data Studio combines a powerful SQL editor with flexible data grids and integrated tools for everyday database work, on your desktop or in the browser.
A SQL editor that knows your schema
The editor is Monaco, the engine behind VS Code, with completion built from the metadata of the connection you are working on: tables, views, columns, procedures and functions appear as you type.
Scripts run the way you expect from SQL Server Management Studio. Batches separated by GO execute one after another on the same connection; a failing batch is reported and the next one still runs.
Schema-aware autocomplete and SQL keywords for every supported database A parameters panel for scripts that take input A Messages pane with PRINT and RAISERROR output, rows-affected counts and errors with script line numbers One result grid per result set, each with the full data grid tool set
Navigate every object
The Data Explorer lists every connection with its tables, views, procedures and functions. Open a table in a grid, a view or a script in the editor, or refresh a connection to pick up schema changes.
Global search queries every enabled connection at once and ranks the matches, so a table name is one keystroke away however many databases you work with.
Connect dialog with recent connections, Test and Connect Edit a saved connection in place and the explorer refreshes its metadata A local workspace for your SQL scripts, JSPython scripts, saved queries and files
Edit data like a spreadsheet
Every table opens in an interactive grid. Edit cells, add rows, delete rows and review the tracked changes before you save them in one statement.
Select ranges with the mouse or the keyboard, copy with headers, paste from a spreadsheet as new rows, and find a column by name in a wide table with the Column Finder.
Column filters: text search, wildcards, value lists, number and date ranges, booleans and custom SQL Sorting and server-side paging, so a large table never has to load completely Row numbers, range selection, Ctrl+C and Ctrl+V
Design, not just query
Schema changes do not need a separate tool. The designers generate the DDL for the database you are connected to.
Indexes and keys
Indexes, unique keys and, on SQL Server, clustered and columnstore indexes, with included columns and filters.
Foreign key relationships
Relationships with ordered column pairs and ON UPDATE / ON DELETE rules, applied in one transaction with the table.
Query Manager
Build a query visually: join related tables, pick the columns, and open the result as a grid you can filter and chart.
Scripts, batch by batch
Falcon Data Studio runs a script the way SSMS does: GO separates the batches, every server message is captured and a failed batch does not stop the rest.
-- Orders per country since the start of the year
SELECT c.Country, COUNT(*) AS Orders, SUM(o.Total) AS Revenue
FROM Sales.Orders AS o
JOIN Sales.Customers AS c ON c.CustomerId = o.CustomerId
WHERE o.OrderDate >= '2026-01-01'
GROUP BY c.Country
ORDER BY Revenue DESC;
GO
PRINT 'Refreshing the country summary';
EXEC Sales.RefreshCountrySummary;
GOEverything you expect from a database IDE
Intelligent SQL editing
Available Monaco with metadata-aware completion, parameters and batch execution.
Database object explorer
Available Tables, views, procedures and functions for every connection, with refresh.
Global search
Available One search over every enabled connection and the local workspace.
Interactive data grids
Available Filter, sort, select, copy, paste, edit and save.
Import and export
Available Stream CSV files into tables; export any grid as CSV, TSV or JSON.
Multiple connections
Available Any number of saved connections across SQL Server, PostgreSQL and Sybase ASE.
Works with the databases you run
Falcon Data Studio ships with providers for three database families and talks to each one natively: SQL Server through Microsoft.Data.SqlClient, PostgreSQL through Npgsql and Sybase ASE through AdoNetCore.AseClient.
- Microsoft SQL Server: Windows authentication, SQL logins and Microsoft Entra multi-factor authentication (desktop app)
- PostgreSQL: full support including the Table Designer, indexes and foreign keys
- Sybase ASE: querying, editing, scripts and import
- Encryption and Trust Server Certificate options per connection; host:port server names
From Raw Data to Working Solutions.
One workspace to connect, query, explore, transform, automate and build.
Whether you are managing databases, engineering pipelines or creating applications, Falcon Data Studio helps you get more from your data.
Start with the modern Data IDE: the Windows desktop app, or open it in your browser.