logologo
Get Started
Guide
Development
Plugins
API
English
简体中文
Get Started
Guide
Development
Plugins
API
English
简体中文
logologo
Overview

Data sources

Data source manager
Main data source

External data sources (Databases)

Overview
External MySQL
External MariaDB
External PostgreSQL
External MSSQL
External Oracle
Main vs External Databases
REST API data source
KingbaseES data source

Collections

Overview
General collection
Inheritance collection
File collection
Tree collection
Calendar collection
Comment collection
Expression collection
SQL collection
View collection

Collection fields

Overview
Field Validation

Basic

Single text
Long text
Phone
Email
URL
Integer
Number
Percent
Password
Color
Icon

Choices

Checkbox
Select
Multiple select
Radio group
Checkbox group

Media

Markdown
Markdown (Vditor)
Rich text
Attachment (Relationship)
Attachment (URL)

Date & Time

Overview
Date & time (with timezone)
Date & time (without timezone)
Unix timestamp
Date (without time)
Time

Geometry

Point
Line
Circle
Polygon

Advanced

UUID
Nano ID
Sort
Formula
Sequence
JSON
Collection select
Encryption

System info

Created at
Updated at
Created by
Last updated by
Space
Table OID

Associations

Overview
One to one
One to many
Many to one
Many to many
Many to many (array)

Development

Overview
Previous PageOverview
Next PageMain data source

#Data Source Manager

#Introduction

NocoBase provides a data source management plugin for managing data sources and their collections. The data source management plugin only provides a management interface for all data sources and does not provide the ability to access data sources. It needs to be used in conjunction with various data source plugins. The data sources currently supported for access include:

  • Main Database: NocoBase's main database, supporting relational databases such as MySQL, PostgreSQL, and MariaDB.
  • External MySQL: Use an external MySQL database as a data source.
  • External MariaDB: Use an external MariaDB database as a data source.
  • External PostgreSQL: Use an external PostgreSQL database as a data source.
  • External MSSQL: Use an external MSSQL (SQL Server) database as a data source.
  • External Oracle: Use an external Oracle database as a data source.

In addition, more types can be extended through plugins, which can be common types of databases or platforms that provide APIs (SDKs).

#Installation

Built-in plugin, no separate installation required.

#Usage Instructions

When the application is initialized and installed, a data source is provided by default to store NocoBase data, known as the main database. For more information, see the Main Database documentation.

#External Data Sources

External databases are supported as data sources. For more information, see the External Database / Introduction documentation.

nocobase_doc-2025-10-29-19-45-33

#Support for Syncing Custom Database Tables

nocobase_doc-2025-10-29-19-46-34

You can also access data from HTTP API sources. For more information, see the REST API Data Source documentation.