# Creating and Editing Databases

Lucy allows you to create databases, store data, and query arbitrary data at any time. These databases are flexible, document-based storage spaces that don't require a strict schema, making them adaptable to various data types and structures.

This article explains how to create new databases and edit them. There are three ways to create a database:

1. [Creating a Database Manually](#id-1.-creating-a-database-manually)
2. [Importing Data from an External Source](#id-2.-importing-data-from-an-external-source)
3. [Using an External Source as a Database](#id-3.-using-an-external-source-as-a-database)

## <mark style="color:blue;">Ways to Create Databases</mark>

Here are the three methods to create a new database in Lucy.

### <mark style="color:blue;">1. Creating a Database Manually</mark>

Databases can be created from scratch or by selecting an built-in template.

For more insights, find the article here.

{% content-ref url="/pages/Nw4RV0Ybm602s8jiqgNm" %}
[Creating a Database Manually](/lucy/my-work-folders/databases/creating-and-editing-databases/creating-a-database-manually.md)
{% endcontent-ref %}

### <mark style="color:blue;">2. Importing Data from an External Source</mark>

You can form databases by importing data from external sources such as data from csv/xlsx files.

For more insights, find the article here.

{% content-ref url="/pages/UPOjgrJbIzSE9bAJf0bI" %}
[Creating a Database by Importing Data from an External Source](/lucy/my-work-folders/databases/creating-and-editing-databases/creating-a-database-by-importing-data-from-an-external-source.md)
{% endcontent-ref %}

### <mark style="color:blue;">3. Using an External Source as a Database</mark>

Lucy allows you to create databases using online data sources such as Google sheets or Excel, eliminating the need for data importing.

For more insights, find the article here.

{% content-ref url="/pages/sGOG93slRX2Mm5AblIIA" %}
[Using an External Source as a Database](/lucy/my-work-folders/databases/creating-and-editing-databases/using-an-external-source-as-a-database.md)
{% endcontent-ref %}

## <mark style="color:blue;">Adding New Data to a Database</mark>

Upon creating a database, you can add new data to it.

To gain more knowledge on adding new data to a database, find the article here:

{% content-ref url="/pages/1yKffxZdGXyfLLX18HZ5" %}
[Adding Data into a Database](/lucy/my-work-folders/databases/adding-data-into-a-database.md)
{% endcontent-ref %}

## <mark style="color:blue;">Editing Databases</mark>

### <mark style="color:blue;">Editing Information in a Database</mark>

Editing Information in a Database refers to updating existing records, inserting new data records, removing unnecessary records from it. In Lucy, tweaking information stored in a database is pretty straightforward and achievable in few simple steps.

For more insights, find the article here.

{% content-ref url="/pages/QOWtOurv7w0OPQqXNzPL" %}
[Editing Data in a Database](/lucy/my-work-folders/databases/editing-data-in-a-database.md)
{% endcontent-ref %}

### <mark style="color:blue;">Editing Fields in a Database</mark>

Modifying, adding, or deleting fields in a database is a straightforward process that can be accomplished in a few simple steps.

For more insights, find the article here.

{% content-ref url="/pages/Fl8o8YejAMZKBGEll5IF" %}
[Editing Fields in a Database](/lucy/my-work-folders/databases/creating-and-editing-databases/editing-fields-in-a-database.md)
{% endcontent-ref %}


---

# 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.iviva.com/lucy/my-work-folders/databases/creating-and-editing-databases.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.