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!

1 Like

@Phat_Nguyen_Truong how do I run the SQL with the test data, I have the table structure and dummie data but when I go to run the SQL, it gives me the same error message, “Error: relation “public.users” does not exist” when trying to select all from a table not named ‘users’

Hi @Chuck1,

Thanks for bringing this to our attention. The error “Error: relation “public.users” does not exist” might indicate that Table Users Schema and its Table Records are not defined.

To quickly help you navigate this, you can send the RunSQL url the via our technical supporter: david.bui@holistics.io so we can help you debug it.

p/s: The data will be used solely for investigation purposes and will not compromise security in any way.

1 Like