mingobase

mingobase

Translate MongoDB query syntax to Supabase JS queries.

Install

npm install mingobase

Requires @supabase/supabase-js as peer dependency.

Usage

import { createClient } from "@supabase/supabase-js";
import { Query } from "mingobase";

const supabase = createClient(url, key);

const query = new Query({ age: { $gte: 18 }, status: "active" });

const { data } = await query
  .find(supabase, "users", ["id", "name", "email"])
  .sort({ createdAt: -1 })
  .limit(10)
  .all();

API

new Query(criteria)

Creates a reusable query with MongoDB-style filter criteria.

query.find(client, collection, projection?)

Returns a cursor with chainable methods:

Method	Description
.sort({ field: -1 })	Sort results (-1 desc, 1 asc)
.limit(n)	Limit results
.skip(n)	Skip first n results
.range(from, to)	Get specific range
.all()	Execute query
.query()	Get raw Supabase query

Projection

// Array syntax
query.find(client, "users", ["id", "name"]);

// Object syntax
query.find(client, "users", { id: 1, name: 1 });

Supported Operators

MongoDB	Supabase
$eq	.eq()
$ne	.neq()
$gt	.gt()
$gte	.gte()
$lt	.lt()
$lte	.lte()
$in	.in()
$nin	.not().in()
$regex	.ilike()
$exists	.is(null) / .not().is(null)
$and	chained filters
$or	.or()

License

MIT