# Database Tools

Starting from **version 4.0.19.09**, ONEWEB introduced **Database Tools** to support low‑code database design and management directly within **AppSpace**. These tools allow application designers and developers to work with database structures visually, without requiring deep database expertise.

Over subsequent releases, ONEWEB expanded this capability to include additional tools that simplify database interaction and exploration.

***

#### **Available Database Tools in AppSpace**

ONEWEB currently provides the following Database Tools:

***

#### **Data Designer**

The **Data Designer** enables users to **design application database schemas visually** using an **ER Diagram–based interface**.

Key capabilities include:

* Designing new database tables
* Defining relationships between tables
* Managing primary and foreign keys
* Importing existing database schemas for re‑engineering or enhancement

This tool helps teams design and maintain data models as part of the application lifecycle.

> Available since **version 4.0.19.09**

***

#### **SQL Builder**

The **SQL Builder** helps users **construct SQL queries visually**, without requiring knowledge of SQL syntax.

Key benefits include:

* Generating SQL queries through a guided UI
* Reducing errors caused by manual SQL writing
* Supporting faster development and prototyping
* Making database querying accessible to non‑SQL users

This tool is especially useful in low‑code environments where speed and usability are critical.

> Available since **version 5.0.21.01**

***

#### **Data Viewer**

The **Data Viewer** provides visibility into database structures and data directly from AppSpace.

Key features include:

* Viewing database tables and schemas
* Inspecting table structures and columns
* Exploring data relationships
* Supporting validation and troubleshooting during development

Data Viewer helps users understand how application data is structured and stored without switching to external database tools.

> Available since **version 5.0.21.01**

***

#### **Role of Database Tools in Low‑Code Development**

Within the **Low‑Code with AppSpace** approach, Database Tools allow teams to:

* Design and manage data models alongside application logic
* Reduce dependency on external database tools
* Improve collaboration between designers and developers
* Maintain consistency between application design and data structure

These tools integrate database design into the same workspace used for UI, process, and service design.

***

#### **Summary**

**Database Tools** in AppSpace enhance ONEWEB’s low‑code development capabilities by bringing database design and interaction into the application workspace.

With **Data Designer**, **SQL Builder**, and **Data Viewer**, ONEWEB enables:

* Visual schema design and management
* Simplified SQL query creation
* Easy inspection of database structures
* Faster and more collaborative application development

Together, these tools support efficient, governed, and scalable database management as part of the overall low‑code application lifecycle.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.onewebstack.com/oneweb-platform-th/building-apps/low-code-with-appspace/database-tools.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
