In Data Management (DMS), common users access databases through a permission request workflow. Request access, query or modify data in the SQL console, and submit tickets for bulk data operations.
Request access and get started
-
Log in to the DMS console and submit a ticket to request permissions on the instance, database, and table you need. For details, see Permission management.
-
After your ticket is approved, open SQLConsole for the target database. Write an SQL statement in the code editor and click Execute. The results appear as a table below the editor, and you can edit the returned data directly. For details, see SQL console and Cross-database query.
-
To change, import, or export data in bulk, submit a ticket for the corresponding operation:
-
Data changes — data modification workflows
-
Import data — bulk imports
-
Data export — large-scale data extraction
-
Available features
| Category | Feature | Description |
|---|---|---|
| Permissions | Permission management | Request permissions on instances, databases, tables, and sensitive fields. View the permissions you currently hold. |
| SQLConsole | SQL console | Run SQL statements against a single database. Use this to verify business code, analyze product effects, and identify issues in an online environment. |
| SQLConsole | Cross-database query | Run join queries across online heterogeneous data sources deployed in different environments. |
| Schemas | Schema design | Create or modify tables when developing or optimizing a project or handling new business requirements. |
| Schemas | Database and table synchronization | Compare and synchronize table schemas across environments, such as online and offline, to keep schemas consistent. |
| Optimization | SQL review | Catch SQL statements that bypass indexes or violate database development standards before they reach production. Protects against SQL injection attacks. |
| Data plans | Data changes | Submit a data change ticket to initialize data for a new project, clean up historical data, fix a bug, or run a test. |
| Data plans | Import data | Submit a data import ticket to load large amounts of data into your databases at once. |
| Data plans | Data export | Submit a data export ticket to extract large amounts of data for analysis. |
| Data plans | Data tracking | Trace historical data changes caused by misoperations or other issues, then run rollback statements to restore data to its previous state. |
| Data plans | Test data generation | Generate test data for scenarios that require frequent data preparation. Ensures data security and discreteness while improving production efficiency. |
| Data plans | Database cloning | Clone MySQL databases. |