# Databases blocks

> 10 blocks in the Databases category.

[All blocks](https://inventor.bot/docs/reference/blocks.md)

| Block | ID | Description |
| --- | --- | --- |
| [Database Lookup (Single)](https://inventor.bot/docs/reference/blocks/databases/db-lookup-single.md) | `db_lookup_single` | Find a single row from a database matching your query. Returns the first matching row. |
| [Database Lookup (Iterator)](https://inventor.bot/docs/reference/blocks/databases/db-lookup-iterator.md) | `db_lookup_iterator` | Find multiple rows from a database and iterate over each one. |
| [Database Create Row](https://inventor.bot/docs/reference/blocks/databases/db-create-row.md) | `db_create_row` | Create a new row in a database with the specified values. |
| [Database Duplicate Row](https://inventor.bot/docs/reference/blocks/databases/db-duplicate-row.md) | `db_duplicate_row` | Duplicate an existing row in a database by its ID. |
| [Database Update Row](https://inventor.bot/docs/reference/blocks/databases/db-update-row.md) | `db_update_row` | Update an existing row in a database with new values. |
| [Clear Row Data](https://inventor.bot/docs/reference/blocks/databases/db-clear-row-data.md) | `db_clear_row_data` | Clear selected columns from a database row. Does nothing if the row does not exist. |
| [Clear Matching Row Data](https://inventor.bot/docs/reference/blocks/databases/db-clear-matching-row-data.md) | `db_clear_matching_row_data` | Find rows matching a query and clear selected columns from all of them. |
| [Update Matching Rows](https://inventor.bot/docs/reference/blocks/databases/db-update-matching-rows.md) | `db_update_matching_rows` | Find rows matching a query and update them all with the specified values. |
| [Delete Matching Rows](https://inventor.bot/docs/reference/blocks/databases/db-delete-matching-rows.md) | `db_delete_matching_rows` | Delete rows matching a query and return how many were deleted. |
| [Database Delete Row](https://inventor.bot/docs/reference/blocks/databases/db-delete-row.md) | `db_delete_row` | Delete a row from a database by its ID. |