Database

Overview of the Built-in Database

PromptChainer has a built-in database that allows you to store, manage, and retrieve data for your AI-driven workflows. This comprehensive database functionality enables you to create custom variables, attach them to specific flows, and activate flows using these variables. It is essential for managing your projects and ensuring smooth and efficient data handling.

Creating and Managing Projects

To create a project in PromptChainer, navigate to the Database interface where you can view your current projects and create new ones. Each project is a container for managing your flows and their related data. By organizing your work into projects, you can keep your flows, variables, and results neatly structured, making it easier to maintain and scale your applications.

Attaching Flows to Projects

Once you've created a project, you can attach specific flows to it. To do this, select a project and choose the flow you want to associate with it. By attaching flows to projects, you enable seamless integration between your flows and the data stored in the project's database.

Activating Flows with Custom Variables

After connecting a flow to a project, you can activate the flow using custom variables from the project's database. Select the variables you want to use in the flow, and then click "Run Selected Flows" to execute the flow with the chosen variables. This feature allows you to customize your flow's behavior and outcomes based on the data stored in the project's database.

Data Storage and Retrieval

The built-in database in PromptChainer provides a convenient data storage and retrieval solution. When you create variables and output nodes in your flows, the database automatically creates corresponding columns for them. This setup enables you to store the results generated by your flows and retrieve them for future use or analysis. By leveraging the database functionality, you can ensure efficient data management and optimize your workflows for maximum effectiveness.