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
    • API

    Overview

    Bytebase provides gRPC and RESTful HTTP API.

    You can manipulate every aspect of Bytebase via API. In fact, the Bytebase UI console is built on the same API. You can use Bytebase as a headless database workflow backend and integrate it with your own internal developer platform.

    • SQL lint

    • Database change deployment

    • Embedded SQL Editor

    Edit this page on GitHub
    Previous articleArchive
    Next articleAuthentication

    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.