Introduction to the SQL Window

Focus Mode

Font Size

Last updated: 2026-04-20 11:11:40

The SQL window provides users with a graphical SQL editor featuring predefined SQL templates and support for user-defined SQL execution, facilitating efficient database querying and management through an intuitive interface.
Feature Description
Add instances for quick login.
Switch between logged-in instances.
View, favorite, and manage databases and tables.
SQL execution panel.
Execute SQL commands and view results
Optimize SQL formats
Save common SQL
Template SQL
Import and export data.
View user permissions.
Region Overview
﻿
No.
Region
Feature Description
1
Logged-in instance display area
The top of the page displays logged-in instances, allowing users to switch between instances for SQL operations.
You can click 
﻿
 on the page to add a quick login instance.
2
Database and table panel
Database
Supports viewing all databases in the current instance, including collections and views.
Supports clicking the Operation button on the right side of the target database to select SQL operations, database management, creating a collection, and other operations.
Collection
Supports viewing all collections in the current database.
Supports clicking the Operation button on the right side of the target collection to select SQL operations, Drop Collection, and other operations.
View
Supports viewing all views in the current database.
Supports clicking the Operation button on the right side of the target view to select the Drop View operation.
Searching databases and collections
The top of the database and table panel supports quick search for collections, databases, and database.collections.
User information
Supports viewing database accounts.
Favorite databases and tables
Click 
﻿
 on the right side of the database or collection. Favorited databases will appear at the top of the non-system database list in the database panel, and favorited collections will be displayed at the top under their respective databases.
3
SQL statement execution area
After entering an SQL statement, click Execute to perform database operations. Additional options include format optimization, clearing SQL statements, and saving the current SQL statement as My Commands.
4
Execution result area
After executing SQL statements, displays execution results, data results, and execution history, with support for data export.
5
Settings
Supports setting the execution timeout.
6
My Commands
Includes system templates and my favorites. The pre-configured system templates cover commonly used commands related to collections, databases, replica sets, and sharding.
User-defined saved SQL statements are displayed in the My Favorites section.
7
Import/Export
Supports data import and export operations.
8
Database Management
Supports creating new databases and viewing existing databases.
9
Viewing permissions
Supports checking the permissions assigned to the currently logged-in account for the instance.

Help and Support

Was this page helpful?

You can also Contact sales or Submit a Ticket for help.

Help us improve! Rate your documentation experience in 5 mins.

Feedback

tencent cloud

Database Management Center

Introduction to the SQL Window

Feature Description

Region Overview

Help and Support

No.	Region	Feature Description
1	Logged-in instance display area	The top of the page displays logged-in instances, allowing users to switch between instances for SQL operations. You can click on the page to add a quick login instance.
2	Database and table panel	Database Supports viewing all databases in the current instance, including collections and views. Supports clicking the Operation button on the right side of the target database to select SQL operations, database management, creating a collection, and other operations. Collection Supports viewing all collections in the current database. Supports clicking the Operation button on the right side of the target collection to select SQL operations, Drop Collection, and other operations. View Supports viewing all views in the current database. Supports clicking the Operation button on the right side of the target view to select the Drop View operation. Searching databases and collections The top of the database and table panel supports quick search for collections, databases, and database.collections. User information Supports viewing database accounts. Favorite databases and tables Click on the right side of the database or collection. Favorited databases will appear at the top of the non-system database list in the database panel, and favorited collections will be displayed at the top under their respective databases.
3	SQL statement execution area	After entering an SQL statement, click Execute to perform database operations. Additional options include format optimization, clearing SQL statements, and saving the current SQL statement as My Commands.
4	Execution result area	After executing SQL statements, displays execution results, data results, and execution history, with support for data export.
5	Settings	Supports setting the execution timeout.
6	My Commands	Includes system templates and my favorites. The pre-configured system templates cover commonly used commands related to collections, databases, replica sets, and sharding. User-defined saved SQL statements are displayed in the My Favorites section.
7	Import/Export	Supports data import and export operations.
8	Database Management	Supports creating new databases and viewing existing databases.
9	Viewing permissions	Supports checking the permissions assigned to the currently logged-in account for the instance.