详细说明,请参考使用限制。
默认情况下,扣子数据库的测试数据和线上数据按下述规则分类。同时,你也可以调整各个发布渠道的数据读写目标,切换渠道访问的是线上数据还是测试数据,详情请参考设置渠道读写配置。
同一工作空间下,无论是低代码智能体还是工作流,只要引用了相同的数据库,就能共享该数据库中的测试数据。
例如,在工作空间 A下创建了智能体 A 和工作流 B,并且智能体 A 和工作流 B 使用了同一个数据库,那么智能体 A 产生的测试数据,在工作流 B 也可查看。
说明
如果工作流数据库节点添加的是应用内创建的数据库,而非资源库中的数据库,那么试运行工作流产生的数据仅限在该应用内查看。
线上数据支持按照发布渠道隔离数据,其渠道隔离规则以你创建数据库时选择的渠道模式为准。例如选择渠道隔离,则表示用户在一个渠道(如飞书)中产生的数据无法在另一个渠道(如微信)查看。
你可以在数据库详情页的测试数据页签中,查看数据库的测试数据,详情请参考查看表数据。
你可以在数据库详情页的线上数据页签中,查看数据库的线上数据,详情请参考查看表数据。
测试数据和线上数据的权限规则可能存在差异,具体如下:
说明
默认情况下,智能体的调试环境和 API Playground 的数据源是隔离的。智能体调试时访问的是测试数据,而调用 API 时访问的是线上数据。若需验证 API 渠道数据,你可以通过如下两种方式配置数据,再进行验证。
扣子编程暂不支持接入本地数据库。你可以开发自定义插件,通过插件方式访问本地数据库。创建自定义插件的步骤,请参考操作导航。
支持将扣子数据库及数据库表导出为本地文件。具体操作,请参考导出表数据。
你可以通过如下方式备份数据库。
使用数据库时遇到保留字段报错,可按照以下步骤处理:
在设计数据库(如定义表名或字段名)时,请避开以下保留字:
ADD
ACTION
ACCOUNT
AES_DECRYPT
AES_ENCRYPT
AFTER
AGGREGATE
ALL
ALGORITHM
ALTER
ALWAYS
ANALYZE
AND
ANY
APPLICATION_PASSWORD_ADMIN
ARRAY
ARMSCII8
ASC
AS
ASCII
ASBINARY
ASIN
ASWKB
ASWKT
ASTEXT
AT
ATAN
ATAN2
ATTRIBUTE
AUDIT_ABORT_EXEMPT
AUDIT_ADMIN
AUTHENTICATION_POLICY_ADMIN
AUTHORS
AUTOCOMMIT
AUTOEXTEND_SIZE
AUTO_INCREMENT
AVG
AVG_ROW_LENGTH
BACKUP_ADMIN
BEFORE
BENCHMARK
BETWEEN
BIG5
BIGINT
BINARY
BIT
BIT_AND
BIT_COUNT
BIT_LENGTH
BIT_OR
BIT_XOR
BLOB
BLOCK
BOOL
BOOLEAN
BOTH
BTREE
BUCKETS
BY
CACHE
CALL
CASCADE
CASE
CAST
CATALOG_NAME
CEIL
CEILING
CENTROID
CHANGE
CHAR
CHARACTER
CHARACTER_LENGTH
CHAR_LENGTH
CHARSET
CHECK
CHECKSUM
CIPHER
CLASS_ORIGIN
CLIENT
CLOSE
CLONE_ADMIN
CLUSTERING
COALESCE
COLLATE
COLUMN
COLUMN_FORMAT
COLUMN_NAME
COLUMNS
COMMENT
COMMIT
COMMITTED
COMPACT
COMPLETION
COMPRESSED
COMPRESS
COMPRESSION
CONCAT
CONCAT_WS
CONDITION
CONNECTION
CONNECTION_ADMIN
CONNECT
CONSISTENT
CONTAINS
CONTEXT
CONVERT
CONVERT_TZ
CONV
CONTRIBUTORS
COPY
CPU
CRC32
CREATE
CREATE_ASYMMETRIC_PRIV_KEY
CREATE_ASYMMETRIC_PUB_KEY
CREATE_DH_PARAMETERS
CREATE_DIGEST
CROSS
CROSSES
CURRENT
CURRENT_DATE
CURRENT_ROLE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURDATE
CURSOR
CURSOR_NAME
CYCLE
DATA
DATAFILE
DATABASE
DATABASES
DATE
DATE_ADD
DATE_FORMAT
DATE_SUB
DATEDIFF
DAY
DAY_HOUR
DAY_MINUTE
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DAY_SECOND
DAY_MICROSECOND
DEC
DEC8
DECIMAL
DEALLOCATE
DECRYPT
DECRYPTION
DECRYPTION_KEY_ID
DECRYPTED
DECRYPTOR
DEFAULT
DEFAULT_AUTH
DEFINER
DELAYED
DELAY_KEY_WRITE
DELETE
DESC
DESCRIBE
DES_KEY_FILE
DETERMINISTIC
DIAGNOSTICS
DISABLE
DISCARD
DISK
DISTINCT
DISTINCTROW
DO
DOUBLE
DUMPFILE
DUPLICATE
DYNAMIC
EACH
ELSE
ELSEIF
EMPTY
ENABLE
ENCLOSED
ENCRYPTED
ENCRYPTION
ENCRYPTION_KEY_ADMIN
ENCRYPTION_KEY_ID
ENFORCED
ENGINE
ENGINES
ENVELOPE
EQUALS
ERROR
ERRORS
ESCAPE
ESCAPED
EVENT
EVENTS
EVERY
EXCHANGE
EXCEPT
EXISTS
EXIT
EXPLAIN
EXPORT
EXPORT_SET
EXTERIORRING
EXTRACT
EXTRACTVALUE
FALSE
FEDERATED
FETCH
FIELD
FIND_IN_SET
FIRST
FIXED
FILTER
FLOAT
FLOAT4
FLOAT8
FLOOR
FOR
FORCE
FOREIGN
FOUND
FOUND_ROWS
FROM
FROM_BASE64
FROM_DAYS
FROM_UNIXTIME
FULL
FULLTEXT
FUNCTION
GENERATED
GET
GET_FORMAT
GET_LOCK
GEOMCOLLFROMTEXT
GEOMCOLLFROMWKB
GEOMETRY
GEOMETRYCOLLECTION
GEOMETRYCOLLECTIONFROMTEXT
GEOMETRYCOLLECTIONFROMWKB
GEOMETRYFROMTEXT
GEOMETRYFROMWKB
GEOMETRYN
GEOMETRYTYPE
GEOMFROMTEXT
GEOMFROMWKB
GENERAL
GLOBAL
GLENGTH
GRANT
GREATEST
GROUP
GROUP_CONCAT
GROUP_REPLICATION
GROUP_REPLICATION_ADMIN
GTID_SUBSET
GTID_SUBTRACT
HASH
HELP
HEX
HIGH_PRIORITY
HISTOGRAM
HISTORY
HOST
HOSTS
HOUR
HOUR_MINUTE
HOUR_SECOND
HOUR_MICROSECOND
IF
IFNULL
IGNORE
IGNORED
IGNORE_SERVER_IDS
IMPORT
IN
INCREMENT
INDEX
INDEXES
INFILE
INNER
INNODB
INOUT
INSTANCE
INSTANT
INTEGER
INT
INT1
INT2
INT3
INT4
INT8
INTO
INVOKE
INVOKER
IPC
IO
IO_THREAD
IS
IS_FREE_LOCK
IS_IPV4
IS_IPV4_COMPAT
IS_IPV4_MAPPED
IS_IPV6
ISOLATION
ISSIMPLE
ISSUER
ITERATE
JOIN
JSON
JSON_ARRAY
JSON_ARRAYAGG
JSON_ARRAY_APPEND
JSON_ARRAY_INSERT
JSON_CONTAINS
JSON_CONTAINS_PATH
JSON_DEPTH
JSON_EXTRACT
JSON_INSERT
JSON_KEYS
JSON_LENGTH
JSON_MERGE
JSON_MERGE_PATCH
JSON_MERGE_PRESERVE
JSON_OBJECT
JSON_OBJECTAGG
JSON_OVERLAPS
JSON_PRETTY
JSON_QUOTE
JSON_REMOVE
JSON_REPLACE
JSON_SCHEMA_VALID
JSON_SCHEMA_VALIDATION_REPORT
JSON_SEARCH
JSON_SET
JSON_STORAGE_FREE
JSON_STORAGE_SIZE
JSON_TABLE
JSON_TYPE
JSON_UNQUOTE
JSON_VALID
JSON_VALUE
KEY
KEY_BLOCK_SIZE
KEYS
KILL
LAG
LANGUAGE
LATERAL
LAST
LAST_INSERT_ID
LAST_VALUE
LEAD
LEADING
LEAVE
LEFT
LENGTH
LCASE
LEAVES
LEAST
LEVEL
LIKE
LIMIT
LINEAR
LINEFROMTEXT
LINEFROMWKB
LINESTRING
LINESTRINGFROMTEXT
LINESTRINGFROMWKB
LINES
LN
LOAD
LOAD_FILE
LOCK
LOCKED
LOG
LOG10
LOG2
LONG
LONGBLOB
LONGTEXT
LOOP
LOWER
LPAD
LTRIM
LOW_PRIORITY
MACCE
MACROMAN
MAKE_SET
MAKEDATE
MAKETIME
MBRCONTAINS
MBRDISJOINT
MBREQUAL
MBRINTERSECTS
MBROVERLAPS
MBRTOUCHES
MBRWITHIN
MD5
MEMBER
MERGE
MESSAGE_TEXT
MID
MICROSECOND
MIN
MIN_ROWS
MINUTE
MINUTE_MICROSECOND
MINUTE_SECOND
MOD
MODIFIES
MODIFY
MONTH
MONTHNAME
MUTEX
MYISAM
MYSQL
MYSQL_ERRNO
NAME
NAMES
NCHAR
NATURAL
NDB
NDB_STORED_USER
NDBCLUSTER
NEXT
NO
NOCACHE
NOCOPY
NO_WRITE_TO_BINLOG
NOCYCLE
NOMAXVALUE
NOMINVALUE
NONET
NODEGROUP
NONE
NTILE
NULL
NULLIF
NUMBER
NVARCHAR
ODBC
OFFLINE
OFFSET
OF
OJ
OLD_PASSWORD
ONE
ONLINE
ONLY
OPEN
OPTIMIZE
OPTIMIZER_COSTS
OPTION
OPTIONAL
OPTIONALLY
OR
ORDER
ORD
ORDINALITY
OUT
OUTER
OUTFILE
OVER
OVERLAPS
OCT
OCTET_LENGTH
OFFSET
OWNER
PACK_KEYS
PAGE
PAGE_CHECKSUM
PAGE_COMPRESSED
PAGE_COMPRESSION_LEVEL
PARTITION
PARTITIONING
PARTITIONS
PASSWORLESS_USER_ADMIN
PASSWORD
PASSWORD_LOCK_TIME
PATH
PHASE
PI
POINT
POINTFROMTEXT
POINTFROMWKB
POINTN
POLYGON
POLYFROMTEXT
POLYFROMWKB
POLYGONFROMTEXT
POLYGONFROMWKB
POSITION
POW
POWER
PREFERENCES
PRECEDES
PRECEDING
PREPARE
PRESERVE
PREV
PRIMARY
PROCEDURE
PROCESS
PROCESSLIST
PROFILE
PROFILES
PROXY
PURGE
QUARTER
QUERY
QUICK
RAND
RANDOM
RANDOM_BYTES
RANGE
RANK
READ
READS
REAL
REFERENCES
RELEASE
RELEASE_LOCK
RELAY
RELAY_LOG_FILE
RELAY_LOG_POS
RELAYLOG
REMOVE
RENAME
REORGANIZE
REPAIR
REPEAT
REPEATABLE
REPLACE
REPLICATE_DO_DB
REPLICATE_DO_TABLE
REPLICATE_IGNORE_DB
REPLICATE_IGNORE_TABLE
REPLICATE_REWRITE_DB
REPLICATE_WILD_DO_TABLE
REPLICATE_WILD_IGNORE_TABLE
REPLICATION
REQUIRE
RESET
RESIGNAL
RESOURCE_GROUP_ADMIN
RESOURCE_GROUP_USER
RESUME
RETAIN
RETURN
RETURNED_SQLSTATE
RETURNING
RETURNS
RESTRICT
REUSE
REVOKE
RIGHT
RL IKE
ROLE
ROLE_ADMIN
ROLLBACK
ROLLUP
ROTATE
ROUTINE
RTREE
ROW
ROW_COUNT
ROW_FORMAT
ROWS
RPAD
RTRIM
S3
SAVEPOINT
SCHEDULE
SCHEMA
SCHEMAS
SCHEMA_NAME
SECOND
SECOND_MICROSECOND
SECURITY
SERVER
SERVICE_CONNECTION_ADMIN
SESSION
SESSION_USER
SHA
SHA1
SHA2
SHARED
SHARE
SIGNS
SIGNAL
SIMPLE
SIGNED
SIN
SOCKET
SOME
SONAME
SOUNDS
SOUNDEX
SPATIAL
SQL
SQL_AFTER_GTIDS
SQL_AFTER_MTS_GAPS
SQL_BEFORE_GTIDS
SQL_BIG_RESULT
SQL_BUFFER_RESULT
SQL_CACHE
SQL_CALC_FOUND_ROWS
SQL_NO_CACHE
SQL_SMALL_RESULT
SQLSTATE
SQLEXCEPTION
SQL_THREAD
SQL_THREAD_WAIT_AFTER_GTIDS
SQLWARNING
SQRT
SSL
STACKED
START
STARTING
STARTS
STARTPOINT
STATS_AUTO_RECALC
STATS_PERSISTENT
STATS_SAMPLE_PAGES
STATUS
STD
STDDEV
STDDEV_POP
STDDEV_SAMP
STOP
STORAGE
STORED
STRCMP
STR_TO_DATE
STRAIGHT_JOIN
STRING
SUBJECT
SUBPARTITION
SUBPARTITIONS
SUBDATE
SUBCLASS_ORIGIN
SUBSTRING
SUBSTRING_INDEX
SUBTIME
SUPER
SUSPEND
SWAPS
SWITCHES
SYSDATE
SYSTEM_USER
TAN
TABLE
TABLE_ENCRYPTION_ADMIN
TABLESPACE
TABLE_TYPE
TEMPORARY
TEMPTABLE
TERMINATED
THAN
THEN
TIMEDIFF
TIME
TIME_FORMAT
TIME_TO_SEC
TIMESTAMP
TIMESTAMPADD
TIMESTAMPDIFF
TINYBLOB
TINYINT
TINYTEXT
TO
TO_BASE64
TO_DAYS
TO_SECONDS
TOKUDB
TOKEN
TRAILING
TRADITIONAL
TRANSACTION
TRANSACTIONAL
TRIGGER
TRIGGERS
TRIM
TRUNCATE
UCASE
UNBOUNDED
UNCOMPRESS
UNCOMPRESSED_LENGTH
UNCOMMITTED
UNDEFINED
UNDO
UNDO_BUFFER_SIZE
UNDOFILE
UNENCRYPTED
UNHEX
UNINSTALL
UNION
UNIQUE
UNIX_TIMESTAMP
UNLOCK
UNSIGNED
UPDATE
UPDATEXML
UPPER
USAGE
USE
USE_FRM
USER
USER_RESOURCES
UUID
UUID_SHORT
VARIABLES
VARBINARY
VARCHAR
VARIANCE
VARYING
VIEW
VALIDATE_PASSWORD_STRENGTH
VALUE
VALUES
VERSION
VERSION_TOKEN_ADMIN
VIRTUAL
VISIBLE
WAIT
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS
WARNINGS
WHEN
WHERE
WHILE
WITH
WITHIN
WKB
WORK
WRAPPER
WINDOW
WITHOUT
X509
XA
XA_RECOVER_ADMIN
XML
XOR
YEAR
YEAR_MONTH
YEARWEEK
ZEROFILL
uuid
sys_platform
bstudio_create_time
在设计数据库(如定义表名或字段名)时,请避开以下保留字。
uuid、sys_platform、bstudio_create_time