RunSQL - A simple tool to create mock database environments to validate your SQL queries

We’re excited to introduce RunSQL, a tool designed to simplify how you test SQL queries and collaborate with others.

As a dbdiagram user, you already appreciate the power of visualizing and designing database schemas with DBML. With RunSQL, we’re taking it a step further by providing an environment where you can test your SQL queries and share results effortlessly.

RunSQL is a simple tool to build sample data and validate SQL queries without the hassle of manual setup. Think of it as a natural extension of dbdiagram, leveraging familiar concepts like DBML while focusing on making SQL workflows seamless.

Converted File to GIF

How it Works

(1) :writing_hand: Define table schemas using DBML: Create database schemas using DBML, a user-friendly, open-source DSL that you’re already familiar of.
(2) :memo: Prepare data samples: Upload datasets from CSV directly from your BI tools or spreadsheets.
(3) :technologist: Execute SQL query instantly: Run your SQL queries against our cloud-based sandboxes.
(4) :handshake: Share and collaborate: Share secure, self-contained environments where your teammates can write, test, and run queries together.

RunSQL is for you if…

  • You’re a data engineer who tests complex SQL daily: testing a complex SQL query against production data can be slow and difficult to verify. Use RunSQL to test queries on a small, curated set of test inputs instead.
  • You’re a data engineer frequently debugging SQL with colleagues: Helping a colleague debug a tricky SQL query? Quickly demonstrate errors or edge cases by sharing test inputs and results in a collaborative environment.
  • You’re a data interviewer testing SQL skills: Conduct SQL interviews effortlessly—create and run SQL challenges in a shared environment. Share your screen with candidates to test their query skills in real-time.

Currently, RunSQL supports PostgreSQL, and we’re working on expanding support to other SQL dialects.

Try RunSQL for free and tell us know what you think!