DMC Database Management
The DMC Database Management Platform is used to manage PostgreSQL databases during development and operations, including schema maintenance, SQL debugging, and data import/export.
DMC is a database management tool and is not recommended as an application access path. For business code, choose SDKs, HTTP APIs, or PostgreSQL direct connections based on the runtime environment. See Connect to your database.
Use cases
| Use case | Description |
|---|---|
| Schema maintenance | Create tables, edit fields, and inspect indexes and constraints |
| SQL debugging | Run queries, DDL, or data repair scripts in the SQL window |
| Data import/export | Import or export data for development, testing, and migration |
| Operations diagnostics | Inspect table data, permissions, functions, triggers, and execution results |
Accessing the DMC Platform
-
Visit the Cloud Development Platform/PostgreSQL Database/Database Settings
-
In the "Account Management" module, create an account and password. Enter the account name, host, password, and other information in the dialog box that appears.
-
After creating the account, click the "Database Management" button to enter the DMC tool page, and log in with the previously created account and password.
SQL Execution
SQL statement execution is a basic feature provided by the PostgreSQL database, allowing developers to process data stored in the database using standard SQL syntax. It is more flexible compared to visual table editing.
After entering the DMC tool, select SQL Window to access the execution panel for SQL statement editing.
Before running production SQL, validate scripts in a test environment and keep execution records. For bulk updates, deletes, and schema changes, confirm backups and rollback plans first.
Import and Export
The PostgreSQL database provides import and export capabilities, making it convenient for developers to perform data migration.
After entering the DMC tool, click the "Floating Toolbar" and select "Import/Export".
For import/export flows and large migration recommendations, see Import data.