Perform fast json queries

In a short time, without any effort.

Get started

Fetch docs in collection

It returns all the docs in "CollectionName" collection.

In SQL: SELECT * FROM CollectionName

Select a field

It returns only fields where name is equal to "_name" from all the docs

Equivalent in SQL: SELECT _name FROM CollectionName

With condition

Returns all documents that match the condition

Equivalent in SQL: SELECT _name FROM CollectionName WHERE _name = "value"

OR condition

Returns all documents that match the conditions

Equivalent in SQL: SELECT _name FROM CollectionName WHERE _name = "value" OR _name = "value2"

Sort docs

Returns all documents sorted by field name. Use -1 or 1 to choose the order.

Equivalent in SQL: SELECT _name FROM CollectionName WHERE _name = "value" OR _name = "value2" ORDER BY _name ASC

Limit docs

Returns all documents limited by a number.

Equivalent in SQL: SELECT _name FROM CollectionName WHERE _name = "value" OR _name = "value2" ORDER BY _name ASC LIMIT 10

From multi collections

Get documents from multi collections

Equivalent in SQL: SELECT * FROM CollectionName1, CollectionName2

Date conditions

Fetch docs by a date condition.

You can combine GT, LT, DateSub, and DateAdd.

Equivalent in SQL: SELECT * FROM CollectionName WHERE created_at > now() - interval '1 month'

Start using Ayaya.

And perform custom queries on your back-end effortlessly.