Xmysql

🚀 One command to generate REST APIs for any MySql Database.

3 followers

Visit website
APIS AND FEATURES 🔥 Generates API for ANY MySql database 🔥 Powerful & Intuitive query interface 🔥 Usual suspects: CRUD, List, Count, Exists, Distinct 🔥 Relations, Paging, Sorting, Filtering (rows & columns too) 🔥 Bulk ops: insert-read-delete 🔥 Aggregate functions, Group By,Chart API 🔥 Multiple table joins !! 🔥 Supports Docker & AWS Lambda
Launch tags:API•Open Source•Developer Tools
Launch Team
Anima - OnBrand Vibe Coding
Design-aware AI for modern product teams.
Promoted

What do you think? …

Navi
NocoDB
Hunter
Hello Product Hunters! Generating REST APIs for an existing (MySql) database which does not follow conventions of frameworks such as rails, django, laravel etc is a hairy adventure that one should better avoid. Hence I started Xmysql - a solution to scratch a simple itch. In the beginning I just needed REST APIs to learn new frontend frameworks such as Vue, Nuxt etc. Early vision of this framework was to build a tool for fast prototyping. In the process of building these APIs - I kept adding features which I felt will be cool. And soon this list grew. Below are the current features. FEATURES: 🔥 Generates API for ANY MySql database 🔥 Serves APIs irrespective of naming conventions of primary keys, foreign keys, tables etc 🔥 Support for composite primary keys 🔥 REST API Usual suspects : CRUD, List, FindOne, Count, Exists, Distinct 🔥 Bulk insert, Bulk delete, Bulk read 🔥 Relations 🔥 Pagination 🔥 Sorting 🔥 Column filtering - Fields 🔥 Row filtering - Where 🔥 Aggregate functions 🔥 Group By, Having (as query params) 🔥 Group By, Having (as a separate API) 🔥 Multiple group by in one API 🔥 Chart API for numeric column 🔥 Auto Chart API - (a gift for lazy while prototyping) 🔥 XJOIN - (Supports any number of JOINS) 🔥 Supports views 🔥 Prototyping (features available when using local MySql server only) 🔥 Run dynamic queries 🔥 Upload single file 🔥 Upload multiple files 🔥 Download file 🔥 Health and version apis 🔥 Use more than one CPU Cores 🔥 Docker support and Nginx reverse proxy config 🔥 AWS Lambda Example In no respect is Xmysql is a complete MVC framework yet. I am currently working on a full feature set of Xmysql which has below features 🔥 Builtin: Authentication, Social Authorization, Sessions, Email, File Scaffolding, Storage 🔥 Payment: Stripe 🔥 Client: Vuejs/Nuxt + Vuetify 🔥 Cloud : Google App Engine 🔥 Microservices: Google cloud functions 🔥 Background tasks: Google Pubsub and Cloud functions Please let me know your feedback and questions on > what can be improved ? Thank you so much for your time.
Navi
NocoDB
Hunter
Xmysql is writting in Node.js ❤️ Setup npm install -g xmysql xmysql -u dbUsername -p dbPassword -d databaseName Happy hackery!
Navi
NocoDB
Hunter
* written :)
Roland Horváth
Awesome idea, awesome execution! I hope authentication and protected routes are on the roadmap 👍
Robert Hessien
@o1lab Hi, really a wonderful tool, but I strongly need to use it with JWT authorization...Do you have any idea if and how I can add it? Is it something that you're already planning to integrate and release as a next feature?
Primer
Songbox
If this actually does what it says on the tin then I’m very excited to try it out.
Navi
NocoDB
Hunter
@mickc79 : Please do try - it won't take more than 30 seconds right from installation :) (assuming you have node and mysql installed)
Brad Bitler
Very cool--thanks!
Umut Muhaddisoğlu
Although didn't try it yet, it looks awesome and an authentication mechanism will definitely make it much more usable.
Fernando Popoca Ortiz
awesome
Mike Hacker

Keep up the amazing work!

Pros:

Very helpful for UI dev work

Cons:

JWT auth would be amazing.

Robert Hessien
Hi, wonderful tool, but I strongly need to use JWT authorization? Do you have any idea if and how I can add it? Is it something that you're already planning to integrate and release as a next feature?
12
Next
Last