What is MySequel Web
MySequel Web is an open source web based GUI tool to access your MySql/Postgresql database. It is similar to PHP My Admin of WAMP. Here you can access any MySql/Postgresql database with proper connection strings. We do not save or store any of your connection strings or data. Every thing related to your connection strings are volatile. You can host this as a simple nodeJs application on any server or you can simply run this in your local.
Demo
You can access https://mysqlweb.herokuapp.com/ for live demo.
To run the application in your machine, Run the app.js file from your cmd prompt
mySequelWeb>node app.js
Then navigate to http://localhost:1234 url by opening your favorite browser.
Except autoconnection field all are mandatory. Please provide your conection string details and click on Access Database
You will get connected with the MySql database and you can see the list tables available in that database.
Write queries in the query editor and click on execute button, your query results will appear in the results grid.
Current Version
Current version is beta
This version has basic features like
- Connecting with MySql/Postgresql Database
- Displaying list of tables
- Displaying table information on table name click
- executing all Select, update, Insert and Delete queries including joins
Upcoming Version
1.0.0 release contains below features.
- In-line edit/update on retrieved records
- adding query snippets for Insert, Update, Select and Delete queries
- Making the grid as fully responsive
- Planning to convert this as electron app, to make it work like stand-alone app
Notes
If you found any issues, feel free to create issues and you are also welcome to contribute to this project. If you like this repo and find it useful, please consider ★ starring it (on top right of the page) and forking it :)