synaticsynaticOfficialยท1 Agent Skills Included

noql

Converts SQL statements into MongoDB queries and pipelines

Converts MySQL and PostgreSQL statements into MongoDB find queries and aggregation pipelines. Eliminates the need to hand-write complex MongoDB syntax for joins, grouping, arrays, dates, and window functions. Returns ready-to-run query objects that plug directly into the MongoDB Node.js driver for faster data access.
npx skills add synatic/noql --all -g -y

All Skills in This Repository (1)

Pure Emerald Level Indicators

Frequently Asked Questions

FAQPage Schema
How to install NoQL?โ–ผ

Run `npx skills add synatic/noql --all -g -y` in your terminal to install this skill globally.

How to convert SQL to MongoDB queries?โ–ผ

Pass any MySQL or PostgreSQL statement to the parseSQL method and it returns a MongoDB find query or aggregation pipeline ready to run with the MongoDB driver.

Does NoQL support joins and grouping?โ–ผ

Yes. It supports inner, left, and full outer joins, GROUP BY aggregates, subqueries, window functions, and join hints like first, last, and unwind.

Which SQL dialects does NoQL support?โ–ผ

NoQL supports both MySQL and PostgreSQL syntax, and generates queries compatible with MongoDB 3.6 or greater.

What SQL features are not supported by NoQL?โ–ผ

Common table expressions, OVER clauses outside window functions, and some union variants are limited, but pivot, unpivot, and UNION ALL are supported.

Related Repositories in Data & Analytics

View All in Data & Analyticsโ†’