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?

  ---

  Connect a database, create a View, build a Query, and run it — in five minutes.

  5-Minute Quick Start →

• 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
Complete my first query end-to-end	5-Minute Quick Start
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

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.