# SQL Plugin

The "SQLPlugin" is your go-to plugin for easy data management. It is your gateway to dynamically handling data without the need for complex coding. This plugin allows you to connect to a database and create, read, update, and delete specific data from your database in real time.

### How to Use?

* Simply drag and drop the SQL plugin into your app's interface.
* Configure the plugin by specifying the [data source](#user-content-fn-1)[^1]. Fetch the tables (entities) and columns (attributes).
* Select the query type, and then use our simple query builder to build the query you require without having to deal with complicated code.

{% hint style="info" %}
**Tip**: Before saving your configuration, validate the query for its accuracy.
{% endhint %}

It's that simple.

### Query Building

Here's a glance at SQL keywords for CRUD operations:

* `CREATE`creates a new entity in the database
* `SELECT`extracts data from the database
* `UPDATE`updates data in the database
* `DELETE`deletes data from the database
* `INSERT INTO`inserts new data into the database

{% hint style="info" %}
**Tip**: Utilize the hotkey "Ctrl+Spacebar" to retrieve a list of these SQL keywords, entities, and attributes to build queries quickly and effortlessly.
{% endhint %}

Here are the sample queries for CRUD operations:

{% code title="Query to create an entity:" %}

```sql
create enity_name (ProductId,ProductName,Category,PurchaseDate) values(?,?,?,?)
```

{% endcode %}

{% code title="Query to select data:" %}

```sql
select CreatedDate,ModifiedDate,CreatedBy,UniqueID from entity_1  where UniqueID=?
```

{% endcode %}

{% code title="Query to insert data:" %}

```sql
insert into entity_1 (CreatedDate,ModifiedDate,CreatedBy) values(?,?,?)
```

{% endcode %}

{% code title="Query to update data:" %}

```sql
update product_info set Category='Infrastructure'    
```

{% endcode %}

{% code title="Query to delete a record:" %}

```sql
delete from entity_1 where UniqueID=?
```

{% endcode %}

{% hint style="info" %}
**Hint**: When dealing with static data, enter the values; when dealing with dynamic data, insert '?' symbols equal to the number of attributes. When dealing with both static and dynamic data, specify values and use '?' in combination.
{% endhint %}

[^1]: Configure this data source in the **Resources** engine that connects to your target database.


---

# 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://help.reasy.ai/help/getting-started/workspace/tools/data-driven-plugins/data-sources/sql-plugin.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.