syamdanda/mysequelweb

MySequel Web is an open source web based GUI tool to access your MySql database. It is similar to PHP My Admin of WAMP. Here you can access any MySQL 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.

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 :)

mysequelweb's Issues

Sometimes query execution is failed due to html tags

Some times when I click on execute query, the query is going with div or span tags for its execution. This is giving error in executing that query.

Enable to connect with postgresql