Introducing RunSQL's SQL Validator

News from RunSQL
1

If you’ve ever spent way too long trying to debug an SQL query, you know how annoying it can get. Whether you’re a seasoned dev, a DBA, or just starting out, syntax errors can seriously mess with your flow.

That’s why the dbdiagram team put together this simple SQL Validator—it’s free and it’ll save you a ton of time.

1200×627 98.7 KB

Here’s what it does for you:

• Missing Semicolon – Reminds you if you forget to add that pesky semicolon at the end.

• SELECT * Queries – Suggests being more specific with your SELECT statements for better performance.

• Missing WHERE Clause – Catches queries that could return too many rows and nudges you to add a WHERE clause.

• JOIN/WHERE Index Checks – If you’ve got schema mode on, it’ll check whether your JOIN or WHERE columns are indexed.

• Complex Subqueries, Window Functions, and LIKE with Leading Wildcards – Spots those performance bottlenecks and gives you suggestions like using CTEs or materialized views.

And much more!

Get Started

:point_right: Try it now: SQL Validator - No signup required.

It’s a little side project from the dbdiagram team, and we built it to make SQL just a little bit easier for you. No sign-ups, no hassle—just quick validation to help you get back to what you’re working on.

1 Like
2

Test for SQL learners using RunSQL?

Hi! I really like the idea of RunSQL. Is there a way to define few datasets and create a quiz based on that? I would like to use it as a certification exam for my students.

3

Hi @Piotr_Menclewicz ,

I’m Huy Le and nice to meet you.

I understand you’re looking to define new datasets and create a quiz for a certification exam using RunSQL. Currently, RunSQL supports:

  • Creating a new run to execute on a specific database engine: Postgres, MySQL, or MS SQL.
  • Modeling tables using DBML.
  • Defining custom datasets for these tables.
  • Running SQL queries on the datasets.

While you can define datasets and test queries, RunSQL doesn’t yet have a built-in feature for creating quizzes directly, such as adding a description section, guidelines, or comparing executed results to expected ones for grading purposes.
Would adding quiz-specific features like these meet your needs for the certification exam, or are there other functionalities you’d require?

Looking forward to your thoughts!

Thanks.