React SQL Query Editor

This project is a SQL query editor built using React, designed to facilitate querying databases with features such as query history, table selection, column selection, efficient result display using Ag Grid, sorting, and export options for CSV and JSON files.

Demo

https://react-sql-query-editor.netlify.app

Features

• Query Editor: Integrated ACE editor for SQL queries.

• Query History: Stores previous queries using browser cookies.

• Table and Column Selection: Multi-select tables and columns for querying.

• Result Display: Uses Ag Grid for efficient display and sorting of query results.

• Export: Options to export query results to CSV and JSON formats.

Tech Stack

Client: React, Context API, TailwindCSS, Axios, AG Grid, react-google-charts,vite

Run Locally

Clone the project

  git clone https://github.com/seeranjeeviramavel/react-sql-query-editor.git

Go to the project directory

  cd my-project

Install dependencies

  npm install

Start the server

  npm run start

License

MIT

🔗 Links