Quick Overview

Introduction

Use this quick overview to place the main database actions in the right order before you build a real flow. You will compare when to query, insert, update, delete, or page records, so the focused operation tours feel like deliberate workflow choices instead of isolated features.

Connect, then Query/Insert/Update/Delete

Pick a focused tour next

Database Operations in Wappler

Wappler provides powerful visual tools for working with databases. You can connect to MySQL, PostgreSQL, SQL Server, and more.

Supported databases + targets

Use Server Actions for DB logic

Creating a Database Connection

First, create a database connection in your project settings. This securely stores your database credentials.

Create connection in project settings

Store credentials securely

Creating Queries

In Server Connect, add a Database Query step. Use the visual query builder to select tables, columns, and add filters.

Build queries visually

Add filters/joins/sort

Inserting Records

Use the Database Insert step to add new records. Map form fields to database columns visually.

Insert new rows

Map form inputs to columns

Updating Records

The Database Update step lets you modify existing records. Set conditions to update specific records.

Update specific rows only

Prefer allow-lists

Deleting Records

Use the Database Delete step to remove records. Always add proper security checks before deleting data.

Confirm intent before deleting

Restrict by auth/session

Next steps

Return to the Database Operations menu to dive deeper into a specific topic like Queries, Insert, Update, Delete, or Paging.

Go back to Database Operations

Choose a deeper tour next