White Paper: Just-in-Time Database Access Best Practices

Bytebase logo
  • 3-in-1
    • Schema Migration
      GUI-based, database CI/CD with GitOps
    • Permission-based SQL Editor
      Bastion-less human-to-database permission control
    • Dynamic Data Masking
      Role-based multi-level masking policy
    • Batch Change
      Multi-environments, multi-regions, multi-tenants
  • Use Case

    • Planned Database CI/CD
    • Just-in-Time Database Access
    • Adhoc Database Change
    • Large-Scale Deployment
    • Headless Database Backend

    Industry

    • Financial Services
    • Technology
    • Manufacturing
    • Gaming
    • Web3
    • Docs
    • Supported Databases
    • Case Study
    • Blog
    • Company
    TutorialStep-by-step guide through common features.
    Start Learning
  • Pricing
...DemoSelf-host
    3-in-1
    Pricing
  • GitHub
  • Self-hostDemo
    • Why Bytebase
    • Supported Databases
    • Use Cases
    • POC Checklist 📝
    • Best Practices 📘
    • Core Concepts 💡
    • FAQ

      • Self-host
      • Upgrade
      • Configure External PostgreSQL
      • Configure External URL
      • Cloud
      • Step 1 - Deploy with Docker
      • Step 2 - Register Accounts
      • Step 3 - Configure Environments
      • Step 4 - Add an Instance
      • Step 5 - Create a Project
      • Step 6 - Change Schema
      • Step 7 - Query Data
    • Connect Your Database
    • Terraform Provider

      • Overview
        • Batch Change
        • Schema Sync
        • Changelist
        • Stored Procedure
        • Schema Editor
        • Schema Diagram
        • Online Schema Migration
        • Secret Variable
        • Overview
        • Review Policy
        • Review Rules
        • UI Integration
        • CI Integration
        • API
        • Custom Approval
        • Rollout Policy
        • Data Rollback
        • Schema Rollback
        • Change History
        • Schema Drift Detection
          • Overview
          • Slow Query Report
          • Weekly Email Report
          • Index Advisor
        • Webhook
        • Risk Center
        • Issue
        • Schema Template
      • Troubleshoot 🐞
      • Overview
      • Release
      • Overview
      • Query
      • Admin Mode
      • Data Masking
      • Manage SQL Scripts
      • Explore Schema
      • AI Assistant
      • Overview
      • Query
      • Export
      • EXPLAIN
      • Overview
      • Semantic Types
        • Masking Algorithm
      • Global Masking Rule
        • Data Classification
      • Column Masking
      • Masking Exemption

      • Single Sign-On
        • OAuth 2.0
        • OpenID Connect (OIDC)
        • LDAP
      • Roles and Permissions
      • User Groups
      • Custom Roles
      • Audit Log
      • SCIM
      • 2FA
      • Password Restriction
      • Sign-in Restriction
      • Watermark
      • Manage License
      • Production Setup
      • Back up Data
      • Database Change Mode
      • AI Assistant
      • Database Instance
      • Environment Policy
      • Customize Logo
      • Announcement
      • SMTP and Email Delivery
      • Archive
      • Overview
      • Authentication
      • SQL Review
      • Release
      • Plan
      • Rollout
      • Issue
      • SQL Editor
      • Permission
      • Data Classification
      • Audit Log
      • Terraform
      • Slack
      • Jira
      • Supabase
      • Render
      • Neon
      • Server Startup Options
      • Error Code for Bytebase Core
      • Error Code for SQL Advisor
      • Schema Definition Language
    • Why Bytebase
    • Supported Databases
    • Use Cases
    • POC Checklist 📝
    • Best Practices 📘
    • Core Concepts 💡
    • FAQ

      • Self-host
      • Upgrade
      • Configure External PostgreSQL
      • Configure External URL
      • Cloud
      • Step 1 - Deploy with Docker
      • Step 2 - Register Accounts
      • Step 3 - Configure Environments
      • Step 4 - Add an Instance
      • Step 5 - Create a Project
      • Step 6 - Change Schema
      • Step 7 - Query Data
    • Connect Your Database
    • Terraform Provider

      • Overview
        • Batch Change
        • Schema Sync
        • Changelist
        • Stored Procedure
        • Schema Editor
        • Schema Diagram
        • Online Schema Migration
        • Secret Variable
        • Overview
        • Review Policy
        • Review Rules
        • UI Integration
        • CI Integration
        • API
        • Custom Approval
        • Rollout Policy
        • Data Rollback
        • Schema Rollback
        • Change History
        • Schema Drift Detection
          • Overview
          • Slow Query Report
          • Weekly Email Report
          • Index Advisor
        • Webhook
        • Risk Center
        • Issue
        • Schema Template
      • Troubleshoot 🐞
      • Overview
      • Release
      • Overview
      • Query
      • Admin Mode
      • Data Masking
      • Manage SQL Scripts
      • Explore Schema
      • AI Assistant
      • Overview
      • Query
      • Export
      • EXPLAIN
      • Overview
      • Semantic Types
        • Masking Algorithm
      • Global Masking Rule
        • Data Classification
      • Column Masking
      • Masking Exemption

      • Single Sign-On
        • OAuth 2.0
        • OpenID Connect (OIDC)
        • LDAP
      • Roles and Permissions
      • User Groups
      • Custom Roles
      • Audit Log
      • SCIM
      • 2FA
      • Password Restriction
      • Sign-in Restriction
      • Watermark
      • Manage License
      • Production Setup
      • Back up Data
      • Database Change Mode
      • AI Assistant
      • Database Instance
      • Environment Policy
      • Customize Logo
      • Announcement
      • SMTP and Email Delivery
      • Archive
      • Overview
      • Authentication
      • SQL Review
      • Release
      • Plan
      • Rollout
      • Issue
      • SQL Editor
      • Permission
      • Data Classification
      • Audit Log
      • Terraform
      • Slack
      • Jira
      • Supabase
      • Render
      • Neon
      • Server Startup Options
      • Error Code for Bytebase Core
      • Error Code for SQL Advisor
      • Schema Definition Language
    • SQL Editor

    Explore the Schema

    SQL Editor displays the database connections in a tree view. This allows users to navigate between different databases to explore the schema.

    This is not available in MongoDB because MongoDB is schemaless.

    Schema

    Edit this page on GitHub
    Previous articleManage SQL Scripts
    Next articleAI Assistant

    All-in-One Database Workflows

    Schema migrations, adhoc changes, just-in-time (JIT) database access, and data masking in one place.

    đŸ•šī¸ Live Demo
    SOC2 badge

    COMPARISONS

    • vs. Liquibase
    • vs. Flyway
    • vs. CloudBeaver
    • vs. DBeaver
    • vs. Navicat
    • vs. Metabase
    • vs. schemachange
    • vs. Jira

    Product

    • Pricing
    • Changelog
    • Documentation
    • API
    • Supported Databases
    • Security

    RESOURCES

    • Resources
    • Terms
    • Policy
    • Partners

    COMPANY

    • About
    • Brand
    • Contact
    Bytebase LogoBytebase logo
    GithubDiscordTwitterYoutubeLinkedIn

    Š 2025 Bytebase. All Rights Reserved.