Documentation

Everything you need to use NexusDB Explorer effectively.

Getting Started

01

Pick a schema

Select a dataset from the sidebar — Agents, Cities, or Incidents — or import your own JSON data.

02

Add a rule

Click "+ Add Rule" to create a condition. Pick the field, choose an operator, and set the value.

03

Group your logic

Use "+ Add Group" to nest conditions. Toggle AND / OR at any level to control how rules combine.

04

Run the query

Hit Run Query (or Ctrl+Enter) to execute against the dataset and see matching results instantly.

05

Export

Copy the generated SQL, MongoDB, or GraphQL from the preview panel, or download it as a file.

Field Types & Operators

String
EqualsNot EqualsContainsDoes Not ContainStarts WithEnds WithMatches RegexIs Empty / Not EmptyIs Null / Not Null
Number
EqualsNot EqualsGreater ThanLess ThanGreater / Less Than or EqualBetweenNot BetweenIs Null / Not Null
Boolean
Is TrueIs FalseIs Null / Not Null
Date
EqualsNot EqualsBeforeAfterBetweenIs TodayIs This WeekIs This MonthIs Null / Not Null
Enum
EqualsNot EqualsInNot InIs Null / Not Null
Array
ContainsDoes Not ContainIs Empty / Not EmptyIs Null / Not Null

Keyboard Shortcuts

Undo last action
Ctrl+Z
Redo
Ctrl+Shift+Z
Run query
Ctrl+Enter
Clear entire query
Ctrl+Shift+C
Export query as JSON
Ctrl+Shift+E
Import query from JSON
Ctrl+Shift+I
Show shortcuts reference
?

Query Formats

SQL

Best for relational databases — PostgreSQL, MySQL, SQLite. Paste directly into your DB client.

SELECT * FROM agents
WHERE clearanceLevel > 5
AND (
  codename LIKE '%Project%'
  OR activeStatus = true
)
ORDER BY lastSeen DESC;
MongoDB

Best for MongoDB queries. Output is a JSON filter object you can drop into a `.find()` call.

{
  "clearanceLevel": { "$gt": 5 },
  "$or": [
    { "codename": { "$regex": "Project" } },
    { "activeStatus": true }
  ]
}
GraphQL

Best for GraphQL APIs that accept structured `where` filter arguments.

query {
  agents(where: {
    clearanceLevel: { _gt: 5 }
    _or: [
      { codename: { _ilike: "%Project%" } }
      { activeStatus: { _eq: true } }
    ]
  }) { id codename }
}

Import Your Data

Query your own datasets alongside the built-in schemas. Data lives in memory — re-import after a page refresh.

Paste a JSON array

  1. 1.Click the "Import" button in the header
  2. 2.Paste a JSON array (e.g. [{"id":1,"name":"Alice"},...]) or NDJSON (one object per line)
  3. 3.Give your dataset a name and click Import
  4. 4.Field types are inferred automatically — strings, numbers, booleans, dates, enums, arrays

Upload a .json file

  1. 1.Click the "Import" button in the header
  2. 2.Drop a .json file or click to browse
  3. 3.The dataset name is taken from the filename automatically
  4. 4.The modal closes instantly — your data is ready to query

Tip: Enums are auto-detected when a field has fewer than 12 unique values. Arrays are detected when values are JSON arrays.