EQQ Knowledge Base¶

Product: Ewarenow Quick Query (EQQ) Version: 26.01 Build 0141 — Extended Edition Publisher: Ewarenow LLC Last updated: April 2026

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.

Where to start¶

Installing EQQ?

Interactive wizard + silent install for Windows Server.

Installation →
First time here?

Sign in, learn the navigation, and explore the Home dashboard.

Getting Started →
Just need to run a query?

Launch an existing query, fill parameters, export results.

Running Queries →
Building new queries?

Design Views and Queries in the visual editor.

Building Queries & Views →
Exposing data via API?

Turn any query into a JSON REST endpoint or a chart.

Visualization & API →
Connecting an AI assistant?

Let Claude / Copilot / Cursor query your data via MCP.

MCP Gateway →
Managing security?

Users, roles, passwords, MFA, API keys.

Administration →
Hit an issue?

Common problems and how to resolve them.

Troubleshooting →

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
Install EQQ on a server	Installation
Run an existing query	Use Queries
Create a new query	Manage Queries
Build a View	Manage Views
Add a reusable function	Manage Functions
Publish a query as REST API	Query To JSON
Connect Claude / Copilot to EQQ data	MCP Gateway
Create an API key	My Account → API Keys
Enable MFA on my account	My Account → MFA
Add/remove users	Security → Users
Adjust password policy	Security → Password Setting
Clone Views/Queries across databases	Advanced → Cloning
Check license usage	Settings → License Manager

Default admin credentials¶

On a fresh install:

Field	Value
Username	`EQQAdmin`
Password	`Fa1l$afe`

Change immediately in production

Sign in, change the password under My Account, and create at least one additional Security Administrator so you are not locked out if EQQAdmin is disabled.