Connecting to a Database

Connections

Introduction

A database connection is the foundation for every Server Connect action that reads or writes data. In this tour, you will look at the connection setup details Wappler needs, understand how driver and credentials affect the target database, and see why this step comes before every query, insert, update, or delete workflow.

Create per target (Dev/Prod)

Reuse in Query/Insert/Update/Delete

Database Connections

Before you can query or modify data, configure a Database Connection for your project target(s). This stores credentials and makes the connection reusable in Server Actions.

Configure a connection per target

Use it across Server Actions

Targets Matter

Make sure your Development and Production targets are configured. Connections are typically created per target.

Development vs Production targets

Keep credentials per environment

Reuse Everywhere

Once created, select the connection in Database Query/Insert/Update/Delete steps.

Select the connection in DB steps

Avoid duplicating credentials

Next steps

Return to the Database Operations menu to continue with Queries, Insert, Update, Delete, or Paging.

Go back to Database Operations

Pick the next focused tour

Database Operations

Browse Database Operations tours: Quick Overview, Connections, and Queries.

Database Operations

Choose a Database Operations tour to start.

Quick Overview

Get a quick overview of Database Operations: what it is, where to find it, and how it fits in your workflow.

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

Database Operations

Browse Database Operations tours: Quick Overview, Connections, and Queries.

Database Operations

Choose a Database Operations tour to start.