Skip to content

A carefully curated list of free online SQL tools, formatters, and converters to optimize and manage database queries.

License

Notifications You must be signed in to change notification settings

99tools/awesome-sql-tools

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 

Repository files navigation

🚀 Ultimate Awesome SQL Resources

Awesome Open Source Love PRs Welcome

A definitively curated, massive list of the best SQL resources, tools, documentation, and learning platforms on the internet. Whether you are a beginner writing your first SELECT statement, a DBA optimizing complex queries, or an engineer preparing for interviews, everything you need is right here.


📑 Table of Contents


🎓 Interactive Learning & Courses

Master SQL from scratch with these interactive platforms and comprehensive tutorials.

  • SQLBolt - Learn SQL with simple, interactive exercises right in your browser.
  • Select Star SQL - An interactive book which aims to be the best place on the internet for learning SQL.
  • SQLZoo - A well-established interactive SQL tutorial with quizzes.
  • Mode SQL Tutorial - Excellent tutorials ranging from Basic to Advanced and Analytical SQL.
  • Codecademy: Learn SQL - Interactive guided course for beginners.
  • W3Schools SQL Tutorial - The classic, easy-to-reference tutorial with a "Try it Yourself" editor.
  • Khan Academy: Intro to SQL - Free video lectures and interactive challenges.
  • PostgreSQL Tutorial - Comprehensive guide specifically for PostgreSQL.
  • MySQL Tutorial - Step-by-step tutorials for MySQL developers.
  • SQLCourse - Unique interactive SQL training.
  • GalaXQL - An interactive SQL tutorial journey through a virtual galaxy.
  • Mystery SQL - Learn SQL by solving a murder mystery in terminal City.

📖 Official Documentation

Always go straight to the source. The official manuals for the most popular relational database systems.

🧪 SQL Playgrounds & Fiddles

Test queries, share schema, and debug database issues without installing anything locally.

  • DB Fiddle - Supports MySQL, PostgreSQL, and SQLite with multiple versions.
  • SQL Fiddle - A tool for easy online testing and sharing of database problems.
  • OneCompiler SQL - Write, run, and share SQL code online.
  • JDoodle SQL Execute - Quick and simple online SQL compiler.
  • Rextester - Online compiler for SQL Server, MySQL, and PostgreSQL.
  • SQLiteOnline - Fast and free online SQLite/MariaDB/PostgreSQL IDE.

🛠️ Web-Based Utilities & Formatters

Browser-based tools to format, minify, generate, and convert SQL data instantly.

  • SQL Utilities - A comprehensive, all-in-one suite featuring SQL formatters, minifiers, JSON/CSV converters, and code generators. Highly recommended for daily workflow.
  • SQLFormat.org - Free online formatter supporting multiple SQL dialects.
  • ExtendsClass SQL Formatter - Beautify and format SQL statements online.
  • CodeBeautify SQL Formatter - Format, validate, and minify your SQL queries.
  • Poor SQL - Instant online T-SQL formatting.

💻 Desktop GUI Clients & IDEs

Manage your databases efficiently with these powerful desktop applications.

  • DBeaver - Free universal database tool for developers and DBAs (Supports all major DBs).
  • DataGrip - JetBrains' powerful database IDE (Paid/Student Free).
  • TablePlus - Modern, native, and friendly GUI tool for relational databases (Mac/Windows).
  • HeidiSQL - Lightweight, free tool for MySQL, MariaDB, PostgreSQL, and MS SQL (Windows).
  • pgAdmin - The most popular and feature-rich Open Source administration platform for PostgreSQL.
  • MySQL Workbench - Unified visual tool for database architects, developers, and DBAs.
  • SQL Server Management Studio (SSMS) - Microsoft's official environment for SQL Server.
  • Sequel Ace - The "macOS-native" database client for working with MySQL/MariaDB.
  • Beekeeper Studio - Open Source SQL editor and database manager with a clean UI.
  • Postico - A modern PostgreSQL client for the Mac.
  • SQuirreL SQL - Graphical Java program to view the structure of a JDBC compliant database.

📊 Database Design & ERD Tools

Plan, visualize, and generate your database schema with Entity-Relationship Diagram tools.

  • dbdiagram.io - Draw entity-relationship diagrams by writing simple code.
  • DrawSQL - Beautiful database diagramming tool for developer teams.
  • QuickDBD - Quickly draw database diagrams by typing.
  • SqlDBM - Online database design tool and entity-relationship modeling.
  • ERDPlus - Web-based database modeling tool for creating ERDs and Relational Schemas.
  • Lucidchart ERD Tool - Enterprise-grade diagramming application.

🎯 Interview Preparation

Practice SQL problems specifically tailored for data science and software engineering interviews.

  • LeetCode Database - Hundreds of SQL interview questions asked by top tech companies.
  • HackerRank SQL - Progressive SQL challenges to earn badges and prepare for assessments.
  • StrataScratch - Practice real SQL interview questions from top companies like Google, Meta, and Amazon.
  • DataLemur - Excellent platform for practicing advanced SQL interview questions.
  • InterviewBit SQL - Curated list of typical SQL interview questions and answers.

🚀 Performance & Optimization

Tools and guides to make your slow queries run lightning fast.

📝 Cheat Sheets & References

Quick lookups for syntax and functions when you're deep in the code.

🗄️ Open Source Sample Databases

Practice your skills on real-world datasets.


🤝 Contributing

Found an amazing SQL resource that isn't listed here? Please send a Pull Request!

  1. Fork this repository.
  2. Add your link in the most relevant category.
  3. Keep the format consistent: * [Tool Name](link) - Brief description.
  4. Submit your PR!

📄 License

CC0

This curated list is dedicated to the public domain.

About

A carefully curated list of free online SQL tools, formatters, and converters to optimize and manage database queries.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors