External Databases

FluxyAPI allows you to connect your existing external databases directly to your projects. Once connected, you can use specialized blocks to perform CRUD (Create, Read, Update, Delete) operations within your API flows.

Core Concept

Instead of providing a built-in database for every project, FluxyAPI gives you the flexibility to Bring Your Own Database (BYOD). This ensures that you maintain full ownership of your data while leveraging FluxyAPI's powerful no-code builder to create endpoints.

Supported Databases

FluxyAPI supports a wide range of relational and NoSQL databases:

• MongoDB (including Atlas/SRV)
• PostgreSQL (including CockroachDB)
• MySQL / MariaDB
• Redis
• ClickHouse
• SQLite

Security & Encryption

Security is our top priority when handling your database credentials:

• AES-256 Encryption: All connection strings are encrypted at rest using industry-standard AES-256 via our Key Management Service (KMS).
• Masked Input: Connection strings are never shown in plain text after they are saved in the dashboard.
• Dedicated Managers: Each database type is handled by a specialized manager that uses optimized connection pooling and secure drivers.

Connecting a Database

To connect a new database, follow these steps:

1. Navigate to the External Databases tab in your project dashboard.
2. Click the Add Database button.
3. Choose a Zone for your database (used for organizing larger projects).
4. Enter a Friendly Name to identify the connection in the builder.
5. Provide the full Connection URI (e.g., postgresql://user:password@host:port/dbname).
6. Click Add Database.

Using Databases in Your Flows

Once a database is connected, you can find specialized blocks for each type in the Database category of the block list.

When configuring these blocks, you will select your database from the Connection dropdown. This dropdown lists all external databases you have added to your project.

Zones and Organization

To help you manage larger projects, external databases can be organized into Zones. Zones act as folders, allowing you to group related database connections together (e.g., "Production", "Staging", or "Microservices").

• Folder View: Databases are displayed in expandable sections based on their assigned zone.
• Access Control: Permissions can be assigned at the zone level, allowing you to control who can create, edit, or delete databases within specific groups.

Subscription Limits

The number of external databases you can connect is determined by your subscription plan: