Babelfish for PostgreSQL adds T-SQL syntax, data types, functions, and SQL Server wire-protocol compatibility to PostgreSQL. It supports a substantial subset of Microsoft T-SQL, but it is not Microsoft SQL Server and this playground is not affiliated with Microsoft.
Use this playground to test common migration queries including IDENTITY columns, INSERT statements, TOP queries, joins, grouping, and aggregates. Compatibility is not complete: MERGE and many enterprise, server-administration, security, replication, and SQL Server Agent features are unavailable.
This page sends your script to a hosted, network-isolated Babelfish 5.4.0 runtime. Every Run executes the whole editor contents against a fresh database, then discards its database state and files. It does not run the database in your browser and it never connects to your own database.
Available output: Native sqlcmd tables, PRINT output, messages, and errors. The schema panel shows a bounded catalogue captured after successful execution. Large output may be truncated, and package installation, remote network access, persistent storage, and external database connections are not supported.
Build a Babelfish script in the editor with syntax highlighting and editor assistance.
Run the complete script against a fresh isolated database sandbox.
Review rows, messages, errors, and execution time in the results panel.
Your draft stays in this browser, and Share creates a separate snapshot link.
CREATE TABLE dbo.users (
id INT IDENTITY(1, 1) PRIMARY KEY,
name NVARCHAR(100) NOT NULL,
team NVARCHAR(50) NOT NULL
);
INSERT INTO dbo.users (name, team)
VALUES (N'Ada', N'Engineering'), (N'Grace', N'Research');
SELECT TOP (10) id, name, team
FROM dbo.users
ORDER BY id;DECLARE @minimum_amount DECIMAL(10, 2) = 100.00;
CREATE TABLE #sales (
sale_id INT PRIMARY KEY,
customer_name NVARCHAR(100) NOT NULL,
amount DECIMAL(10, 2) NOT NULL
);
INSERT INTO #sales (sale_id, customer_name, amount)
VALUES (1, N'Ada', 125.50), (2, N'Grace', 89.99), (3, N'Linus', 210.00);
SELECT TOP (2) sale_id, customer_name, amount
FROM #sales
WHERE amount >= @minimum_amount
ORDER BY amount DESC;CREATE TABLE dbo.orders (
order_id INT IDENTITY(1, 1) PRIMARY KEY,
total_amount DECIMAL(10, 2) NOT NULL
);
GO
INSERT INTO dbo.orders (total_amount)
VALUES (75.00), (125.50), (210.00);
GO
CREATE PROCEDURE dbo.orders_over
@minimum DECIMAL(10, 2)
AS
BEGIN
SET NOCOUNT ON;
SELECT order_id, total_amount
FROM dbo.orders
WHERE total_amount >= @minimum
ORDER BY total_amount DESC;
END;
GO
EXEC dbo.orders_over @minimum = 100.00;
GOThe editor uses Monaco, the engine behind VS Code, with language-aware editing tools and familiar keyboard controls.
Write your query in the editor, then click Run (or press Ctrl/Cmd + Enter) to execute it.
Results appear instantly in the output panel below, along with any errors and how long the query took.
Nothing to install and no account to create — queries run in a hosted, isolated database sandbox.
Smart autocomplete and syntax highlighting for your query language
Real-time error underlines, bracket matching, and code folding
Multi-cursor editing plus find & replace (Ctrl/Cmd + F)
One-click formatting to tidy up long queries
Copy to clipboard and download your script
Built on Monaco — the same editor that powers VS Code
Run the whole editor script and see its native results
Output shows returned rows, messages, errors, and execution time
Start from a clean database every run, so experiments never clash
Switch between light and dark themes
Adjust font size and other editor settings
Toggle side-by-side or top/bottom layouts
Enter distraction-free fullscreen mode
Generate a shareable link to your exact query in one click — no login needed
Your work autosaves to your browser, so you can pick up where you left off
Copy your query to the clipboard or download it as a file
Run query: Ctrl/Cmd + Enter
Find & replace: Ctrl/Cmd + F
Open the full shortcut list from the keyboard icon in the toolbar