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
Wispr Flow: Dictation That Works Everywhere
Wispr Flow: Dictation That Works Everywhere
Stop typing. Start speaking. 4x faster.
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