Studio 3T 是Studio 3T團隊開發的GUI可視化工具。可以讓用戶方便使用工具進行新增、刪除、修改、查詢、監控等操作
Query MongoDB faster
IntelliShell
Auto-complete queries in a built-in mongo shell that highlights syntax errors as you type and saves your query history.
Visual Query Builder
Perfect for MongoDB beginners, a time-saver for pros. Use a drag-and-drop UI to build complex find() queries and filter array elements.
Aggregation Editor
Break down aggregation queries into manageable steps and build them stage by stage, for easier debugging and querying.
SQL Query
Put your SQL skills to good use. Query MongoDB with SQL using SELECT, DISTINCT, GROUP BY, INNER JOIN, LEFT JOIN, and more.
AI Helper – Natural Language Query Builder
User-friendly Interface for MongoDB
AI Helper is designed as a user-friendly interface for MongoDB that enables users to easily build queries, even if they don’t have coding experience. This feature can be especially helpful for non-technical personnel such as sales engineers and CFOs.
AI-powered Query Support
AI Helper provides AI-powered support for writing complex queries, including nested queries and aggregations. This feature helps users to save time and simplify the query-writing process.
Query Script Generation
AI Helper generates scripts to run your database queries. This feature enables users to automate their query processes and makes it easier to run queries on a regular basis.
Accelerate and optimize
Query Code
Generate instant code in JavaScript (Node.js), Java (2.x and 3.x driver API), Python, C#, PHP, and Ruby from MongoDB and SQL queries that you can copy and paste into your application.
Index Manager
Quickly find indexes and see at a glance how often they are used. Hide and unhide indexes without having to drop them or wait for them to rebuild. Fine tune your indexes for faster queries, with multiple filter options and index types.
Query Profiler
Find slow running queries, investigate, and fix MongoDB queries to speed up performance. Profiling data for find and aggregate queries is presented in a format that’s easy to understand and all in one place. Spot missing indexes instantly.
Schema Explorer
Find mistakes fast. Run schema analyses on your MongoDB collections to reveal data outliers, misspellings, duplicates, and other anomalies that you can fix on the spot.
Migrate without the headache
SQL ↔ MongoDB Migration
The easiest way to migrate between SQL and MongoDB. Import Oracle, PostgreSQL, MySQL, SQL Server, Sybase, and IBM DB2 to MongoDB, or export MongoDB collections to a SQL file or database.
Import & Export Wizard
Import to MongoDB from JSON, CSV, BSON/mongodump, and SQL, and get a preview of your output documents as you make changes. Export entire MongoDB collections, views, queries, query results, or specific documents to the same formats.
Manage your database
Connection Manager
Connect to as many MongoDB connections as you want, with the option to enable proxy support, activate read-only lock mode, and use SCRAM-SHA-256, SCRAM-SHA-1, X.509, Kerberos (GSSAPI), and LDAP authentication—without long loading times.
Table, Tree & JSON Views
Discover the most flexible MongoDB viewer. Open any MongoDB collection and show embedded fields next to parent fields with Table View, collapse or expand fields in Tree View, or browse entire documents in JSON View.
User & Role Managers
Add, edit, and remove users in just a few clicks, assign roles to individual users, and list out all users by role through a convenient MongoDB UI.
|
STUDIO 3T Basic Studio 3T Basic includes:
|
STUDIO 3T Pro Studio 3T Pro includes:
|
STUDIO 3T Ultimate Studio 3T Ultimate includes:
|
| Free | Basic | Pro | Ultimate | |
| Basics | ||||
| MongoDB Versions | 3.0 to 6.0 (Free, Basic, Pro & Ultimate) | |||
| Operating System | Windows (64-bit), macOS, Linux (64-bit) (Free, Basic, Pro & Ultimate) | |||
| Data Presentation | ||||
| Table, Tree, and JSON Views | V | V | V | V |
| In-Place Editing (Table and Tree Views) | V | V | V | |
| Collection View | V | V | V | |
| Search in Table, Tree, and JSON Views | V | V | V | |
| Value search across server, database, and collection | V | V | V | |
| Batch updates of fields | V | V | V | V |
| Query Writing and Tuning | ||||
| IntelliShell with Auto-Completion | V | V | V | V |
| SQL Query | V | V | ||
| Visual Query Builder | V | V | V | |
| Query History and Bookmarks | V | V | V | |
| Default Query | V | V | V | |
| JSON Document Validation | V | V | V | |
| Visual Explain | V | V | V | |
| Query Code Generation: Mongo shell, Javascript (Node.js), Java, Python, C#, PHP, Ruby | V | V | ||
| Query Profiler | V | V | ||
| Index Management | V | V | V | V |
| AI Helper | V | V | V | |
| Aggregation Editor | ||||
| Execute full pipeline at command | V | V | V | |
| Change individual stages on demand | V | V | V | |
| View complete outputs of each stage | V | V | V | |
| View all stages of a query in one view | V | V | V | |
| Open and save queries as JavaScript (.js) files | V | V | V | |
| Duplicate stages | V | V | V | |
| Copy & paste queries throughout the app | V | V | V | |
| Import/Export | ||||
| JSON | V | V | V | |
| CSV | V | V | V | |
| BSON | V | V | V | V |
| Another MongoDB Collection | V | V | V | |
| MySQL | V | V | ||
| MS SQL Server | V | V | ||
| PostgreSQL | V | V | ||
| Sybase | V | |||
| Oracle | V | |||
| IBM DB 2 | V | |||
| Export SQL with Incremental Execution | V | |||
| Excel | V | V | V | |
| Migration: | ||||
| SQL to MongoDB | V | |||
| MongoDB to SQL | V | |||
| Migration to SQL with Incremental Execution | V | |||
| Data Masking | V | |||
| Schema Analysis, Design and Optimization | ||||
| Schema Explorer | V | V | ||
| Data Compare & Sync | V | V | ||
| Reschema (schema optimization) | V | |||
| GridFS Support | V | V | V | |
| Schema Validator | V | V | V | |
| Map-Reduce | V | V | V | |
| Connectivity | ||||
| Direct Connection | V | V | V | V |
| Connection Manager | V | V | V | V |
| SQL Connection Manager | V | V | ||
| Sharded Cluster | V | V | V | V |
| Replica Set | V | V | V | V |
| Replica Set Members’ Live Status Update | V | V | V | V |
| Connection via Proxy | V | V | V | V |
| SSH Tunnel Integration | V | V | V | V |
| SSL Support | V | V | V | V |
| Connection Folders | V | V | V | V |
| Copy/Paste MongoDB URIs to Connect | V | V | V | V |
| Import/Export Connection to URI | V | V | V | V |
| Customization | ||||
| Dark Theme | V | V | V | V |
| Session Restore | V | V | V | |
| Collection History | V | V | V | |
| Customizable Shortcuts and Keymap | V | V | V | V |
| Authentication & Security | ||||
| Read-Only Lock | V | V | V | |
| Cryptographic Key Store | V | V | V | V |
| SCRAM-SHA-1 Authentication | V | V | V | V |
| SCRAM-SHA-256 Authentication | V | V | V | V |
| X.509 Authentication | V | V | V | V |
| Kerberos (GSSSAPI) Authentication | V | |||
| LDAP (PLAIN) Authentication | V | |||
| AWS (IAM) Authentication | V | |||
| Operations | ||||
| Tasks | V | V | V | |
| Task Scheduler | V | V | V | |
| Real-Time Server Status Charts | V | V | V | |
| Color-coded Connections and Database | V | V | V | |
| Team Sharing | ||||
| Drag and drop DB Connection to share | V | V | V | |
| Drag and drop Query script to share | V | V | V | |
| User & Role Management | ||||
| Collection Management | Limited | V | V | V |
| User Management | V | V | V | |
| Role Management | V | V | V | |
| View Management | V | V | V | |
| Account Benefits | ||||
| Enterprise Installer | V | |||
| Priority Support | V | |||