Back to ProjectsDeveloper Tool

SQL Query Runner

Web app for running SQL queries with real-time results and syntax highlighting.

Tech Stack

ReactMERNMySQL

Overview

SQL Query Runner is a browser-based SQL IDE that lets developers write and execute MySQL queries against a connected database and see results instantly in a table view. Features syntax highlighting, query history, and result export.

Key Highlights

  • CodeMirror SQL editor with syntax highlighting
  • Live query execution against MySQL
  • Result table with pagination
  • Query history log

How I Built It

React frontend with CodeMirror for the SQL editor (syntax highlighting, autocomplete). Node.js/Express backend connects to MySQL and executes queries, returning results as JSON. Query history is stored in MongoDB.

Future Vision

Add support for PostgreSQL and SQLite, schema browser, query explain/analyze view, and team collaboration features.

Links