Skip to content

Integrations · Database

Group: Database
Deep link: /_Admin/system/config?SiteId={siteGuid}&group=Database

The Database group configures external database and cache connections plus built-in SQLite options. After save, scripts use k.DB.mysql, k.DB.sqlServer, k.DB.mongo, k.DB.redis, etc.; if unset or invalid, matching Database menus show onboarding pages.

Database group

Integration Items

NameDescriptionAdmin menu
MysqlMySQL ConnectionStringMySQL tables
SqlServerSQL Server ConnectionStringSQL Server tables
MongoMongoDB connection stringScript k.DB.mongo
RedisRedis ConnectionStringScript k.DB.redis
SqliteBuilt-in SQLite options (e.g. ForeignKeyConstraint); not a connection stringSQLite tables (out of the box)

When editing Mysql / SqlServer, dialog Alerts often include connection string examples per Kooboo built-in docs, e.g.:

text
Server=...;Port=3306;Database=...;Uid=...;Pwd=...
Data Source=...;Initial Catalog=...;User ID=...;Pwd=...

Default Database

Basic Settings · Advanced Default database (defaultDatabase) decides where k.DB.sql points: Auto priority is MySQL > SQL Server > SQLite.

SQL Log

Whether relational SQL is written to SQL logs is controlled by site enableSqlLog (Advanced tab or SQL log page), independent of Database group config.