Skip to content

EQQ Knowledge Base

Product: Ewarenow Quick Query (EQQ) Version: 26.01 Build 0141 - Extended Edition Publisher: Ewarenow LLC

What is EQQ?

EQQ (Ewarenow Quick Query) is a web-based platform that lets non-technical users build, govern, and publish SQL queries against one or more relational databases - without writing raw SQL by hand.

Queries are assembled from Views (schema projections), enriched with Functions (reusable transformations), parameterized, versioned through a clear lifecycle, and then exposed to end users as:

  • Interactive result grids (Use Queries)
  • JSON REST endpoints (Query To JSON)
  • Charts (Query To Chart)

The platform also includes user/role security, MFA, API keys for machine-to-machine access, per-database scoping, and license-controlled usage.

Philosophy

Separate the data model (Views) from the question (Queries) from the delivery (JSON / Chart / Grid). Each can be governed independently.

Which of these are you?

  • I just need to run a report

    Find an existing query, fill in a couple of fields, export your data. No setup, no SQL.

    Run Your First Query →

  • I need to build a new query

    Connect a database, design a View, build a Query - in about five minutes.

    Build Your First Query →

  • I'm setting EQQ up for my team

    Install EQQ, add users and roles, activate your license.

    Set Up EQQ →

  • I want an AI assistant to query my data

    Connect Claude, Copilot, or Cursor over MCP, or call the REST API directly.

    Connect an AI Assistant →

Already know EQQ and just need to look something up? Jump straight to the Reference section.

The big picture

flowchart LR
    DB[(Source Databases)] --> V[Views<br/>Governed projections]
    V --> Q[Queries<br/>Parameterized questions]
    FN[Functions<br/>fQQ_*] --> Q
    Q -->|Grid| UQ[Use Queries]
    Q -->|JSON| API[Query To JSON]
    Q -->|Chart| CH[Query To Chart]
    UQ --> User([End Users])
    API --> Dev([Developers])
    CH --> User

Quick reference

Task Where to go
Complete my first query end-to-end Build Your First Query
Run an existing query Run Your First Query
Install EQQ on a server Installer
Create a new query or View Views & Queries
Add a reusable function Functions
Publish a query as REST API or chart Visualization & API Delivery
Connect Claude / Copilot to EQQ data MCP Gateway
Manage users, roles, or the license Administration
Diagnose a problem Troubleshooting

Default admin credentials

Field Value
Username EQQAdmin
Password Set during installation

First sign-in

Sign in with EQQAdmin and the password you chose in the installer. Create at least one additional Security Administrator so you are not locked out if EQQAdmin is ever disabled.