# Bytebase

> Bytebase is a unified platform for governing how teams access and change any database. It covers Database Change Management, Database Access Control, and Database Compliance for 20+ database types including PostgreSQL, MySQL, MongoDB, SQL Server, ClickHouse, and more.

## Product

- [Bytebase — The standard for database governance](/index.md): Bytebase is a unified platform for governing how teams and AI agents access and change any database.
- [About Bytebase](/about.md): We're changing the way teams and AI agents work with databases
- [Bytebase for Enterprise](/enterprise.md): Standardize how teams and AI agents change, access, and audit databases across the enterprise.
- [Database Change Management](/database-change-management.md): Bytebase automates database change workflows with built-in review, rollback, and optional GitOps integration so teams work from the same process.
- [Database Audit Logging](/database-audit-logging.md): An audit trail of every database action tied to a real identity: SSO identity, full SQL, approvals, and masking decisions captured at the gateway — one format across PostgreSQL, MySQL, SQL Server, and Oracle, mapped to SOC 2, HIPAA, and PCI DSS. Bytebase records the workflow layer (actions routed through it); connections that bypass it need engine-native auditing as a backstop. Self-hosted, open-source.
- [Database as Code](/database-as-code.md): Run your database as code: schema and migrations in version control, automated SQL review, pull-request approvals, CI/CD deployment, and drift detection. Self-hosted, open-source.
- [Database Change Automation](/automate-database-change.md): Automate database change end to end: a GitOps change pipeline, automated SQL review, risk-tiered approvals, rollback, and a complete audit trail. Self-hosted, open-source.
- [Database Governance for AI Agents](/database-governance-ai-agents.md): Govern what AI agents read and write in your database. In Bytebase an agent authenticates with its own identity — a service account or workload identity — that inherits the same governance as a human user — just-in-time access, masking, and audit on reads, plus SQL review, approval, and rollback on writes — over MCP, across PostgreSQL, MySQL, SQL Server, and Oracle. Not vanilla IAM (auth only) or PAM (credential/session layer). Self-hosted, open-source.
- [SQL Review](/sql-review.md): Catch unsafe SQL before it reaches production: 100+ automated review rules across linting, schema-aware semantic checks, and risk-based approval, wired into your CI/CD pipeline. Self-hosted, open-source.
- [Online Schema Migration for MySQL](/online-schema-migration.md): Run large MySQL schema changes without downtime. Bytebase picks Online DDL or gh-ost by table size, drives the shadow-and-cutover, and throttles on replica lag — all behind SQL review, approval, and audit. Self-hosted, open-source.
- [Dynamic Data Masking](/dynamic-data-masking.md): Mask sensitive columns at query time, not at rest: role-based policies, classification-driven rules, unmask approval, and a full audit trail — one policy across PostgreSQL, MySQL, SQL Server, Oracle, BigQuery, and Snowflake. Masking covers the human read path through Bytebase (SQL Editor, query results, exports), not the application's direct connection. Self-hosted, open-source.
- [SQL Editor](/sql-editor.md): Query production through one governed web SQL editor: shared connections, just-in-time access, dynamic data masking, and a full audit log. Open-source.
- [Just-in-Time Database Access](/just-in-time-database-access.md): Replace standing privileges with just-in-time database access: request, approve, and auto-revoke time-bound, least-privilege grants, fully audited. Open-source.
- [Database Access Control](/database-access-control.md): Grant least-privilege, just-in-time access through approval workflows, with dynamic data masking and a full audit trail. A zero-trust path to production data — no standing credentials, every query accountable.
- [Database Compliance](/database-compliance.md): From schema changes to data access, Bytebase records who did what, when, and why across every environment.
- [Bytebase Pricing](/pricing.md): Community (free), Pro ($20/user/month), and Enterprise (custom) plans.
- [Bytebase, compared](/compare.md): Bytebase compared, side by side: schema migration tools, SQL clients, and database access platforms.
- [Amazon RDS Pricing (AWS) — On-Demand & Reserved](/dbcost/rds-pricing.md): On-demand and reserved monthly pricing for every Amazon RDS (AWS) instance, across PostgreSQL, MySQL, and MariaDB, in every region.
- [Amazon Aurora Pricing (AWS) — On-Demand & Reserved](/dbcost/aurora-pricing.md): On-demand and reserved monthly pricing for every Amazon Aurora (AWS) instance, across Aurora PostgreSQL and Aurora MySQL, in every region.
- [Google Cloud SQL Pricing (GCP) — Enterprise & Enterprise Plus](/dbcost/cloudsql-pricing.md): On-demand monthly pricing for every Google Cloud SQL machine type, across Enterprise and Enterprise Plus, for MySQL and PostgreSQL, in every region.
- [Azure Database for PostgreSQL & MySQL Pricing — Flexible Server](/dbcost/azure-flexible-server-pricing.md): On-demand and reserved monthly pricing for every Azure Database for PostgreSQL and MySQL Flexible Server machine type, across Burstable, General Purpose, and Memory Optimized, in every region.
- [Google AlloyDB Pricing (GCP)](/dbcost/alloydb-pricing.md): On-demand monthly pricing for every Google AlloyDB machine shape — PostgreSQL-compatible, per vCPU and per GB, in every region.
- [Azure SQL Database Pricing — vCore, Every Service Tier](/dbcost/azure-sql-database-pricing.md): On-demand and reserved monthly pricing for every Azure SQL Database vCore configuration, across General Purpose, Business Critical, and Hyperscale, in every region.
- [PostgreSQL Data Masking — Dynamic Masking Without an Extension](/databases/postgres/data-masking.md): Role-based dynamic data masking for PostgreSQL. No extension, no superuser — one policy across community Postgres, RDS, Aurora, Cloud SQL, and AlloyDB, with approval workflow and audit.
- [PostgreSQL Schema Migration — Database CI/CD for Postgres](/databases/postgres/schema-migration.md): A Postgres schema change is one ALTER TABLE — instant, ungoverned, and hard to take back. Bytebase puts it on a CI/CD pipeline: every change reviewed, rolled out by stage, approved, and audited across community Postgres, RDS, Aurora, Cloud SQL, and AlloyDB.
- [MySQL Data Masking — One Policy Across Every Edition and Fork](/databases/mysql/data-masking.md): Role-based dynamic data masking for MySQL. No Enterprise license, no view inventory, no proxy — one policy across Community, Enterprise, Percona, MariaDB, RDS, and Aurora, with approval workflow and audit.
- [MySQL Schema Migration — Database CI/CD for MySQL](/databases/mysql/schema-migration.md): MySQL has no transactional DDL — a multi-statement migration that fails leaves the table half-applied, with no rollback. Bytebase puts MySQL change on a CI/CD pipeline: reviewed, run online through gh-ost when an ALTER would lock, staged, approved, and audited across Community, Percona, MariaDB, RDS, and Aurora.
- [SQL Server Data Masking — Beyond Native DDM's Display Filter](/databases/sql-server/data-masking.md): SQL Server has Dynamic Data Masking, but Microsoft calls it a display filter, not a security boundary — WHERE-predicate inference leaks the real value. Bytebase governs the query path with role-based masking, approval workflow, and audit across SQL Server, Azure SQL, and RDS.
- [SQL Server Schema Migration — Database CI/CD for SQL Server](/databases/sql-server/schema-migration.md): On SQL Server the deploy script is often generated — a DACPAC diff or an SSMS one-off that runs before anyone reads it. Bytebase puts SQL Server change on a CI/CD pipeline: every change reviewed, staged, approved, and audited across SQL Server, Azure SQL, Managed Instance, and RDS — so a generated drop-and-add never reaches production unread.
- [Oracle Data Masking — Past Data Redaction's License and Leaks](/databases/oracle/data-masking.md): Oracle Data Redaction is a paid Advanced Security add-on on Enterprise Edition — and a WHERE predicate still leaks the value while SYSDBA and EXEMPT holders read cleartext. Bytebase governs the query path with role-based masking, approval, and audit across every Oracle deployment, no license required.
- [Oracle Schema Migration — Database CI/CD for Oracle](/databases/oracle/schema-migration.md): An Oracle schema is a web of dependencies — alter one table and the packages, views, and triggers that reference it go INVALID. Bytebase puts Oracle change on a CI/CD pipeline: reviewed, staged so the invalidations surface first, approved, and audited across Enterprise, Standard, Autonomous, Exadata, and RDS.
- [PostgreSQL MCP Server — Governed Agent Access to Postgres](/databases/postgres/mcp-server.md): A governed MCP server for PostgreSQL. Agents connect through Bytebase, not a connection string — per-agent identity, masking on the read path, writes reviewed as change issues, and every action audited.
- [MySQL MCP Server — Governed Agent Access to MySQL](/databases/mysql/mcp-server.md): A governed MCP server for MySQL. Agents connect through Bytebase, not a DSN — per-agent identity, masking on the read path, writes reviewed as change issues, and every action audited across Community, Percona, MariaDB, RDS, and Aurora.
- [SQL Server MCP Server — Governed Agent Access to SQL Server](/databases/sql-server/mcp-server.md): A governed MCP server for SQL Server. Agents connect through Bytebase, not a connection string — per-agent identity, masking that sysadmin and native DDM can't bypass, writes reviewed as change issues, and every action audited across SQL Server, Azure SQL, and RDS.
- [Oracle MCP Server — Governed Agent Access to Oracle](/databases/oracle/mcp-server.md): A governed MCP server for Oracle. Agents connect through Bytebase, not a connection string — per-agent identity, masking with no Advanced Security license that SYSDBA can't bypass, writes reviewed as change issues, and every action audited across Enterprise, Standard, Autonomous, and RDS.

## Cloud Database Pricing

- [Amazon RDS instance pricing](/dbcost/rds/instance.md): Per-instance Amazon RDS pricing — specs and monthly cost across regions and engines.
- [Amazon RDS instance comparisons](/dbcost/rds/compare.md): Compare Amazon RDS instances by size, side by side.
- [Amazon Aurora instance pricing](/dbcost/aurora/instance.md): Per-instance Amazon Aurora pricing — specs and monthly cost across regions and engines.
- [Amazon Aurora instance comparisons](/dbcost/aurora/compare.md): Compare Amazon Aurora instances by size, side by side.
- [Google Cloud SQL instance pricing](/dbcost/cloudsql/instance.md): Per-instance Google Cloud SQL pricing — specs and monthly cost across regions and engines.
- [Google Cloud SQL instance comparisons](/dbcost/cloudsql/compare.md): Compare Google Cloud SQL instances by size, side by side.
- [Google AlloyDB instance pricing](/dbcost/alloydb/instance.md): Per-instance Google AlloyDB pricing — specs and monthly cost across regions and engines.
- [Azure Database for PostgreSQL / MySQL Flexible Server instance pricing](/dbcost/azure-flexible/instance.md): Per-instance Azure Database for PostgreSQL / MySQL Flexible Server pricing — specs and monthly cost across regions and engines.
- [Azure Database for PostgreSQL / MySQL Flexible Server instance comparisons](/dbcost/azure-flexible/compare.md): Compare Azure Database for PostgreSQL / MySQL Flexible Server instances by size, side by side.
- [Azure SQL Database instance pricing](/dbcost/azure-sql/instance.md): Per-instance Azure SQL Database pricing — specs and monthly cost across regions and engines.

## Brand & Design

- [Brand Guidelines](/brand.md): The full Bytebase brand system — strategy, verbal identity, logo, brand device, color, typography, iconography, illustration.
- [Design Tokens](/design.md): Machine-readable brand color and typography tokens in the design.md format, the source of truth mirrored by the Brand Guidelines.

## Customer Case Studies

- [Lucid Software — How Lucid Gives Engineers Safe, Self-Service Access to Production Databases with Bytebase](/customers/lucid.md): How Lucid Software replaced an ops-gated, manual query-request process with safe self-service production database access using Bytebase.
- [note — How note.com Implements Just-in-Time (JIT) Database Access Control with Bytebase](/customers/note-com.md): How note.com implemented JIT database access control using Bytebase, reviewing thousands of changes while maintaining compliance.
- [LayerX — How LayerX Achieves "Painless" Governance and Security in the Cloud](/customers/layerx.md): How LayerX built a cloud-native governance framework that balances compliance, security, and developer agility using Bytebase.
- [PayerMax — How PayerMax Integrates Security and Compliance into its Database Development Workflow](/customers/payermax.md): How PayerMax brought security and compliance guardrails into every stage of its database development workflow with Bytebase.
- [CVTE — How CVTE Uses Bytebase to Manage Factory Databases](/customers/cvte.md): How electronic manufacturing corporation CVTE achieves more secure and streamlined database change management with Bytebase.
- [Salla — How Salla Uses Bytebase to Build the Shopify for the Arab World](/customers/salla.md): How the Saudi-based e-commerce platform consolidates database change and access management with Bytebase.
- [Longbridge — How Longbridge Whale Uses Bytebase to Manage Database per Tenant Architecture](/customers/longbridge.md): How financial service SaaS provider Longbridge Whale solved schema changes in tenant mode with Bytebase.

## Blog

- [The Evolution of PostgreSQL Schema Migrations: Less Locking, Less Rewriting, Less Downtime](/blog/postgres-schema-migration-evolution.md): How PostgreSQL evolved from blocking DDL toward concurrent operations, metadata-only changes, and deferred constraint validation.
- [Top 5 Free, Open Source SQL Clients and Database Management Tools (2026)](/blog/top-open-source-sql-clients.md): The best free, open-source SQL clients and database management software in 2026. Compare DBeaver, Beekeeper Studio, DbGate, HeidiSQL, and Bytebase — free database programs for Mac, Windows, and Linux — on license, engine coverage, and team access.
- [Just-in-Time Database Access with AWS RDS IAM Authentication](/blog/just-in-time-database-access-with-aws-rds-iam.md): RDS IAM authentication replaces a stored database password with a 15-minute token. This reference implementation adds the rest of the JIT path: a scoped IAM role, verified identity, a bounded session, approval in Git, and an honest look at the four limits that remain.
- [PostgreSQL vs MySQL: Which Database Should You Choose in 2026?](/blog/postgres-vs-mysql.md): PostgreSQL 18 vs MySQL 9.7 LTS compared on license, optimizer, JSON, security, replication and operability, plus which workloads actually decide the choice.
- [What Postgres is Missing for AI Agents](/blog/what-postgres-is-missing-for-ai-agents.md): Four missing primitives: delegation, attenuation, immutable application context, and labels on data. GRANT and RLS are a good policy engine, but nothing trustworthy feeds it when the caller is an AI agent. Oracle and SQL Server solved pieces of this; Postgres has none of it.
- [Bytebase vs. Delphix: a tale of two data masking stories](/blog/bytebase-vs-delphix.md): Bytebase and Delphix both mask sensitive data, but at different points: Delphix masks non-production copies, Bytebase masks live production queries.
- [Database Deployment Tools for DevOps Teams in 2026](/blog/database-deployment-tools.md): A practical look at the database deployment tools DevOps teams actually use in 2026 — Flyway, Liquibase, Atlas, pgschema, Octopus Deploy, Harness, DBmaestro and Bytebase — sorted by how each one defines, applies, and coordinates schema changes.
- [Top Database Schema Migration Tools to Avoid Change Outage 2026](/blog/top-database-schema-change-tool-evolution.md): Compare the top database schema migration tools of 2026: Flyway, Liquibase, Atlas, Alembic, Skeema, goose, dbmate, Prisma, and Bytebase, plus a decision table.
- [Database Credentials Management: Best Practices](/blog/database-credentials-management-best-practices.md): Database credentials management best practices: store passwords and secrets in one place, rotate on a schedule, and separate the application path from the human path.
- [Best Secrets Manager for Database Credentials in 2026: Vault vs Infisical vs Doppler](/blog/best-secrets-manager-for-database-credentials.md): Comparing HashiCorp Vault, Infisical, Doppler, and 1Password, the vendor-neutral options for database credentials that work across clouds and on-prem.
- [On-Behalf-Of Database Access for AI Agents](/blog/on-behalf-of-database-access-for-ai-agents.md): On-behalf-of (OBO) is the pattern for AI agents to act with a caller's delegated identity instead of a shared credential. No mainstream database engine carries it the way agents need, and here is why a governance layer in front of the database is where it has to live.
- [Top Postgres SQL Review Tools in 2026](/blog/top-postgres-sql-review-tools.md): Postgres SQL review tools compared: SQLFluff for style, Squawk for migration safety, plpgsql_check and pgTAP, and where Bytebase fits as the approval layer.
- [Top Dynamic Data Masking Tools in 2026](/blog/top-dynamic-data-masking-tools.md): Dynamic data masking tools compared: native in Oracle, SQL Server, Snowflake, BigQuery, MySQL, an extension for Postgres, plus cross-database platforms.
- [Dynamic Data Masking Best Practices](/blog/dynamic-data-masking-best-practices.md): How to run dynamic data masking so it survives an audit: mask by role, go column-level, log unmask events, review policy changes in code, and keep environments in sync. Plus a vendor comparison and an end-to-end walkthrough.
- [MCP vs. CLI: How an AI Agent Should Reach Your Database](/blog/mcp-vs-cli.md): Compare direct database CLI access with a governed MCP server across six dimensions: setup, reach, identity, governance, auditability, and workflow fit.
- [MySQL vs. MariaDB: a Complete Comparison in 2026](/blog/mysql-vs-mariadb.md): MySQL vs. MariaDB in 2026: licensing, features, vector search, cloud support, and where each shines. Updated for MySQL 9.7 LTS and MariaDB 11.8 LTS.
- [Zero Trust for Databases: From Access Control to SQL Control](/blog/zero-trust-for-databases-access-control-sql-control.md): Zero trust for databases extends identity and network controls to SQL statements, query results, data changes, and schema changes.
- [Top Database DevOps Tools in 2026](/blog/top-database-devops-tools.md): The top database DevOps tools in 2026 by category: CI/CD, SQL lint, backup, data masking, observability, access management, secrets, and all-in-one.
- [Object Tagging: The AI Feature Almost Every Production Database Skipped](/blog/database-object-tagging.md): Snowflake and the data warehouses can tag any database object with structured metadata and drive masking from it. Almost no production database can. In the LLM era, that inline, self-contained context is exactly what agents need.
- [Understanding DynamoDB Pricing (2026)](/blog/understanding-dynamodb-pricing.md): Explain the pricing details of DynamoDB
- [Understanding AWS RDS Pricing (2026)](/blog/understanding-aws-rds-pricing.md): Explain the pricing details of AWS RDS
- [AWS Aurora Pricing Explained: Instance Types, Serverless, and Cost Optimization (2026)](/blog/understanding-aws-aurora-pricing.md): Complete guide to AWS Aurora pricing: instance types and costs, Aurora Serverless v2 pricing, I/O-Optimized vs Standard, reserved instance savings, and real-world cost examples. Learn how to optimize your Aurora costs.
- [Understanding Google Cloud SQL Pricing](/blog/understanding-google-cloud-sql-pricing.md): In the post, we explore the Google Cloud SQL pricing structure, tools for estimating its cost, and tips for optimizing the cost.
- [Understanding Google Cloud AlloyDB Pricing (updated for 2026)](/blog/understanding-google-alloydb-pricing.md): Explain the pricing details of Google Cloud AlloyDB and compare it with Google Cloud SQL
- [Bytebase vs. DbUp: from migration runner to unified governance](/blog/bytebase-vs-dbup.md): DbUp runs your .NET migrations. Bytebase governs the database: change, access, and compliance in one platform. A practitioner comparison.
- [How to Govern Data at the Source: A Guide to Upstream Database Governance](/blog/govern-data-at-the-source.md): Database governance lives upstream, on the production database. Here is how to actually govern the source: reviewed changes, scoped access, codified policy, and audit where the data is born.
- [Primary Key vs Foreign Key: What Are the Differences?](/blog/primary-key-vs-foreign-key.md): Primary key vs foreign key: what each does and how they differ on uniqueness, NULLs, indexing, and relationships, with SQL examples and a comparison table.
- [Top SQL Editors for PostgreSQL in 2026](/blog/top-pg-only-sql-editor.md): The best SQL editors built exclusively for PostgreSQL: what each one is good at, who it fits, and when a Postgres-only tool beats a multi-database client.
- [Top Open Source Postgres Migration Tools in 2026](/blog/top-open-source-postgres-migration-tools.md): The top open source Postgres migration tools in 2026: Flyway, Liquibase, Atlas, Sqitch, pgroll, graphile-migrate, pgschema, and Bytebase compared.
- [pgAdmin vs. DBeaver: a Complete Comparison in 2026](/blog/pgadmin-vs-dbeaver.md): An extensive comparison between pgAdmin and DBeaver on features, user experience, database support, extensibility, performance, and more.
- [Choose the Right Golang ORM or Query Builder in 2026](/blog/golang-orm-query-builder.md): Review the state of the Golang ORM and query builder in 2026
- [Top TypeScript ORM 2026](/blog/top-typescript-orm.md): Evaluate several TypeScript ORMs, and help you to choose the right one for 2026
- [MySQL vs SQL Server: Key Differences and Which to Choose (2026)](/blog/mysql-vs-sqlserver.md): MySQL 9.7 LTS vs SQL Server 2025: real license math (per-server vs per-core), concurrency model differences, edition gating, and an honest decision framework.
- [Drizzle ORM vs Prisma: Which TypeScript ORM Should You Use in 2026?](/blog/drizzle-vs-prisma.md): Drizzle ORM vs Prisma comparison: type safety, performance, bundle size, serverless support, migrations, and ecosystem. Find out which TypeScript ORM is right for your project in 2026.
- [Prisma vs TypeORM: The Better TypeScript ORM in 2026](/blog/prisma-vs-typeorm.md): Evaluate Prisma and TypeORM, and help you to choose the right TypeScript ORM for 2026
- [RDS Alternatives in 2026](/blog/rds-alternatives.md): Explore alternatives to Amazon RDS in 2026: Aurora, Cloud SQL, AlloyDB, Azure, DigitalOcean, Aiven, TigerData, and the serverless Postgres providers, with cost comparisons.
- [MySQL Hosting Options in 2026: Pricing Comparison](/blog/mysql-hosting-options-pricing-comparison.md): Compare the price of the mainstream managed MySQL hosting providers
- [Top DataGrip Alternatives 2026](/blog/top-datagrip-alternative.md): DataGrip is a database IDE developed by JetBrains and closely integrated with the JetBrains ecosystem. If you prefer a dedicated database GUI, here are the top DataGrip alternatives in 2026.
- [Top MySQL Workbench Alternatives 2026](/blog/top-mysql-workbench-alternative.md): If you work exclusively with MySQL, MySQL Workbench is an excellent choice for a database GUI, but if you work with multiple databases, you need to look elsewhere. This article highlights five database GUI alternatives for MySQL Workbench.
- [Top 6 Text-to-SQL Query Tools in 2026](/blog/top-text-to-sql-query-tools.md): An overview of the most popular text-to-SQL AI tools in 2026, including DataGrip, TablePlus, Vanna.ai, SQLAI.ai, DBHub MCP server, and Bytebase SQL Editor. Compare features and capabilities to find the best SQL AI assistant for your workflow.
- [Top 10 PostgreSQL Extensions 2026](/blog/top-postgres-extension.md): What are the top Postgres extensions you may need to enhance your Postgres instance in 2026.
- [Top pgAdmin Alternatives 2026](/blog/top-pgadmin-alternative.md): pgAdmin is the default Postgres GUI, but it is not the only one. Here are the top pgAdmin alternatives in 2026.
- [Top Postgres Monitoring Tools and Best Practices in 2026](/blog/top-postgres-monitoring-tools.md): Reviewing postgres monitoring tools and best practices in 2026.
- [Top Open Source MySQL Migration Tools in 2026](/blog/top-open-source-mysql-migration-tools.md): What are the top open source MySQL schema migration tools in 2026 - Skeema, Liquibase, Flyway, and Bytebase compared.
- [Top Navicat Alternatives 2026](/blog/top-navicat-alternative.md): Navicat is a long-established database GUI, but it falls short in multi-user scenarios where team collaboration and centralized control are needed. Here are the top Navicat alternatives in 2026.
- [Top DBeaver Alternatives 2026](/blog/top-dbeaver-alternative.md): DBeaver is one of the most popular database management tools. If it doesn't fulfill your requirements or you want to try something new, here are the top DBeaver alternatives in 2026.
- [PostgreSQL Hosting Options in 2026: Pricing Comparison](/blog/postgres-hosting-options-pricing-comparison.md): Compare the price of the mainstream managed PostgreSQL hosting providers
- [Snowflake vs. Redshift: a Complete Comparison in 2026](/blog/snowflake-vs-redshift.md): An extensive comparison between Snowflake and Redshift on features, architecture, development workflow, operability, pricing and more.
- [Oracle vs. PostgreSQL: a Complete Comparison in 2026](/blog/oracle-vs-postgres.md): An extensive comparison between Oracle and PostgreSQL on data model, query language, scalability, performance, and more.
- [Top 4 Free, Open Source Database Schema Diagram Tools in 2026](/blog/top-database-schema-diagram-tools.md): Compare the top free, open-source database schema diagram tools in 2026 (DrawDB, ChartDB, Azimutt, and Liam ERD) by database support, workflow, and project momentum.
- [What is Write Ahead Logging (WAL)](/blog/write-ahead-logging.md): What write-ahead logging is, the steal/no-force theory behind it, and how SQL Server, Oracle, MySQL, PostgreSQL, and SQLite each implement redo and undo differently.
- [What's New in MySQL 9 - a DBA's Perspective](/blog/what-is-new-in-mysql-9.md): Overview of MySQL 9 features with spicy comments
- [What is Enterprise Database Management (EDM)?](/blog/what-is-enterprise-database-management.md): What enterprise database management actually comprises: the five practice areas, a self-assessment rubric, and why the ops/dev seam is where it breaks down.
- [What is Database Schema Drift?](/blog/what-is-database-schema-drift.md): Database schema drift is when the actual schema in the live database differs from the source of truth. How drift happens, why it causes outages, and how to detect and fix it.
- [What is Database DevSecOps?](/blog/what-is-database-devsecops.md): Database DevSecOps integrates security throughout the database development lifecycle. The threats and controls for each of the four access paths, from schema migration to AI agents.
- [What is Database DevOps?](/blog/what-is-database-devops.md): Database DevOps integrates DevOps practices into database work. Why the database lagged a decade behind code CI/CD, the typical workflow it replaces, and how to measure whether you actually have it.
- [What is Database Activity Monitoring (DAM)?](/blog/what-is-database-activity-monitoring-dam.md): What Database Activity Monitoring is, how the four collection architectures differ, the vendor landscape, and where DAM stops short of prevention.
- [Top 5 Open Source, Online SQL Editors You can Self-host](/blog/top-open-source-online-sql-editors.md): The open source, self-hostable, web-based SQL editors compared honestly, with per-tool verdicts and a fresh repository-activity check.
- [Top 10 Database Schema Design Best Practices](/blog/top-database-schema-design-best-practices.md): The top 10 database schema design best practices, ranked by what each mistake costs to fix once the table holds real data. With PostgreSQL snippets.
- [Postgres Row-Level Security (RLS) Limitations and Alternatives](/blog/postgres-row-level-security-limitations-and-alternatives.md): While PostgreSQL RLS is a powerful feature, it has inherent design limitations that hinder broader adoption. In this post, we’ll examine these limitations and explore alternatives.
- [Modern Snowflake Stack in 2026](/blog/modern-snowflake-stack.md): The "Modern Snowflake Stack" refers to the set of technologies and tools built around Snowflake for data ingestion, transformation, security, and analytics. First mapped in early 2024, refreshed for 2026 after a wave of mergers and acquisitions reshuffled nearly every layer.
- [What is Database Version Control?](/blog/database-version-control.md): What database version control is, why versioning a stateful system is harder than versioning code, the mechanics (migration files, version tables, checksums), and the honest limits of rollback.
- [Database Compliance for HITRUST: Controls, Risks, and Best Practices](/blog/database-compliance-for-hitrust.md): A practical guide to HITRUST database compliance covering access control, audit logging, change management, and data protection.
- [Database Compliance for GDPR: Implications and Best Practices](/blog/database-compliance-for-gdpr.md): What seven years of GDPR enforcement teach database teams: the fines cluster around data topology, database breaches, and shadow data. The concrete database controls that address each.
- [Database Compliance for LGPD: Implications and Best Practices](/blog/database-compliance-for-lgpd.md): What LGPD means for database operations: how it actually differs from GDPR, what the ANPD sanctions in practice, and the database controls (classification, masking, retention, audit) that hold up.
- [Top Open Source Database Governance Tools in 2026](/blog/top-open-source-database-governance-tools.md): Database governance controls how production databases are changed and accessed; data governance catalogs what lands downstream. The terms are conflated in every search, so this post covers the top open-source tools on both sides of the line.
- [Data Governance vs. Database Governance: The Difference Is the Base](/blog/data-governance-vs-database-governance.md): Data governance and database governance are four letters apart and constantly conflated. They are different disciplines, owned by different teams, solved by different tools. Here is the dividing line.
- [Bytebase vs. PopSQL: a side-by-side comparison for migrating teams](/blog/bytebase-vs-popsql.md): PopSQL shuts down on September 1, 2026. Compare Bytebase and PopSQL across query collaboration, supported databases, access control, data masking, audit logging, and pricing before you migrate.
- [Top PopSQL Alternatives 2026: Where to Migrate Before the Shutdown](/blog/top-popsql-alternative.md): PopSQL shuts down on September 1, 2026. Compare the top PopSQL alternatives for team SQL editing, dashboards, and governed database access before you migrate.
- [Top 4 Open Source Postgres Connection Poolers (2026)](/blog/open-source-postgres-connection-pooler.md): The best open-source Postgres connection poolers in 2026. Compare PgBouncer, Odyssey, PgDoorman, and PgDog — with our pick: PgBouncer if you want free, PgDog if you want a commercial vendor.
- [Flyway vs. Liquibase: The Definitive Comparison in 2026](/blog/flyway-vs-liquibase.md): Flyway vs Liquibase: features, pricing, databases, rollback, drift detection, and a when-to-choose guide. Updated for Flyway 12.9.0 and Liquibase 5.0.3.
- [GitHub vs Bitbucket: a Complete Comparison in 2026](/blog/github-vs-bitbucket.md): GitHub vs Bitbucket in 2026: how the two Git platforms compare on hosting, CI/CD, AI coding agents, security, and pricing, and which one to pick.
- [Aurora vs. RDS: engineering guide to choose the right AWS database for 2026](/blog/aurora-vs-rds.md): An engineering perspective to evaluate Amazon Aurora and RDS, and help you to choose the right AWS database for 2026
- [Top 6 Postgres Schema Compare Tools to Diff and Sync Databases in 2026](/blog/top-postgres-schema-compare-tools.md): A Postgres schema compare tool diffs and synchronizes schemas between PostgreSQL databases. This 2026 guide reviews the top 6 tools — pg-schema-diff, Atlas, Liquibase, pgAdmin, Navicat, and Bytebase — and how to choose.
- [Top 3 Open Source Multi-Database MCP Servers in 2026](/blog/top-open-source-multi-database-mcp-servers.md): The best multi-database MCP servers in 2026. Compare DBHub, Google's MCP Toolbox for Databases, and Bytebase on engine breadth, host neutrality, and governance for connecting AI agents to more than one database. Single-engine Postgres servers are covered in a companion post.
- [Top 6 MySQL Schema Compare Tools to Diff and Sync Databases in 2026](/blog/top-mysql-schema-compare-tools.md): A MySQL schema compare tool diffs and synchronizes schemas between MySQL databases. This 2026 guide reviews the top 6 common tools in this category and how to choose.
- [Top 3 Open Source Postgres MCP Servers in 2026](/blog/top-open-source-postgres-mcp-servers.md): The best open source Postgres MCP servers in 2026. Compare Postgres MCP Pro, Supabase MCP, and pgconsole on host neutrality, access model, and governance for connecting AI agents to PostgreSQL. Multi-database MCP servers are covered in a companion post.
- [Bytebase vs. SchemaHero: a side-by-side comparison for database schema migration](/blog/bytebase-vs-schemahero.md): SchemaHero and Bytebase both ship schema changes to your database, but from opposite instincts: declarative Kubernetes reconciliation versus a reviewed, audited change pipeline. A side-by-side look at approach, supported databases, governance, and cost.
- [Database Governance for Fintech: Guarding the Ledger](/blog/database-governance-for-fintech.md): Money software is judged not on whether the feature works, but on what the database can prove eighteen months later. Fintech database governance through three principles: no invented data, no lost data, no trust.
- [Why It's So Hard to Add a Column in the Middle of a PostgreSQL Table](/blog/why-its-hard-to-add-a-column-in-the-middle-of-postgres-table.md): PostgreSQL has no ADD COLUMN ... AFTER. The reason one little number in a system catalog turned a "simple" feature into a decade-long engineering saga, and what you can do about it today.
- [Bytebase vs. DataGrip: a side-by-side comparison for database management](/blog/bytebase-vs-datagrip.md): DataGrip is a SQL IDE built for individual developers; Bytebase is a web platform built for teams that need review and governance. This post compares their database support, features, and pricing to help you decide which fits.
- [How to Integrate Automatic SQL Review into GitHub](/blog/integrate-sql-review-into-github.md): Run automatic SQL review on every GitHub pull request. A single GitHub Action connects to your Bytebase server to enforce 200+ schema-aware rules and post results as PR comments — before any change is deployed.
- [What is a Database MCP Server?](/blog/what-is-a-database-mcp-server.md): What a database MCP server actually hands an AI agent, how a query runs through one, and why a raw connection-string server is fine on your laptop but risky against production.
- [Database Version Control, State-based or Migration-based?](/blog/database-version-control-state-based-vs-migration-based.md): We dive into the rationale behind the industry divergence between state-based and migration-based approaches. Migration-based still leads in 2026 even as Atlas brings state-based to Database as Code. In the end, we show how Bytebase gets the best of both worlds.
- [Governed MCP vs. Raw MCP: How Agents Reach Your Database](/blog/governed-mcp-vs-raw-mcp.md): Most database MCP servers hand an agent a connection string and call it a day. The MCP server is the one place agent database access is governed or wide open.
- [When the Agent Writes the Migration, Who Approves It?](/blog/governing-agent-authored-database-changes.md): AI agents are no longer just reading your database, they are authoring the migrations. The write path is a different risk class, and it needs its own gate.
- [What is Database PAM (Privileged Access Management)?](/blog/what-is-database-pam.md): Generic PAM controls the database connection. Database PAM controls the SQL statement: per-query authorization and approval, SQL review, data masking, and statement-level audit. What the category means and why it exists.
- [SQL Server Schema Migration and Change Management](/blog/sql-server-schema-migration-guide.md): How to run SQL Server schema migrations safely in production, covering state-based vs migration-based workflows, online index operations, batched backfills, the expand-and-contract pattern, and CI/CD.
- [Supabase Pricing vs AWS RDS: Is Supabase Free? Full Cost Comparison (2026)](/blog/supabase-vs-aws-database-pricing.md): Is Supabase free? Compare Supabase pricing vs AWS RDS and Aurora across free tier, Pro, and production plans. Includes Supabase free tier limits, storage costs, and compute pricing for 2026.
- [Supabase vs. MongoDB: a Complete Comparison in 2026](/blog/supabase-vs-mongodb.md): Supabase and MongoDB take different paths to storing application data. This article compares them on data model, architecture, performance, pricing, and licensing to help you decide which one fits.
- [Bytebase vs. CyberArk: the database vertical in your PAM stack](/blog/bytebase-vs-cyberark.md): CyberArk is a broad privileged access management (PAM) platform. Bytebase is a database-specific PAM for access control, masking, and SQL review. If you already run CyberArk, here is why you still need it for the database.
- [PostgreSQL 19 features I'm excited about](/blog/postgres-19-features-im-excited-about.md): PostgreSQL 19 features I'm excited about: planner advisor framework, DDL extraction, online REPACK, pg_stat_recovery, parallel autovacuum, sequence sync, and 64-bit MultiXact.
- [Postgres Timeout Explained](/blog/postgres-timeout.md): Explain why Postgres provides a variety of timeout settings.
- [Postgres best practices I wish every app developer knew](/blog/postgres-best-practices-i-wish-app-developers-knew.md): PostgreSQL best practices for application developers: connection naming, timeouts, online migrations, role separation, and UPSERT for reliable production apps.
- [Just-in-Time Database Access](/blog/just-in-time-database-access.md): Just-in-Time database access — the use cases, the traditional workflow and its blind spot, and how Bytebase governs the SQL, not just the request.
- [MySQL Audit Logging Guide](/blog/mysql-audit-logging-guide.md): The practical ways to audit MySQL activity, from the general query log to audit plugins, binlog CDC, and Bytebase, and where each one falls short.
- [The Standard for Database Development](/blog/standard-for-database-development.md): Every critical asset has its system of record, except the database. Bytebase is the one. The standard for database development.
- [How to Implement Dynamic Data Masking: Five Approaches by Access Path](/blog/how-to-implement-dynamic-data-masking.md): Dynamic data masking is chosen by access path, not product. Five approaches (engine-native, in-database, application, BI layer, and Bytebase) and which caller each one masks.
- [Static vs Dynamic Data Masking: When to Use Which](/blog/static-vs-dynamic-data-masking.md): Static vs dynamic data masking, when each applies, how they differ on backups, performance, and reversibility, and when to run both.
- [Static Data Masking Tools (and How to Roll Your Own)](/blog/static-data-masking-tools.md): The static data masking tools that produce safe non-production data, Delphix, Tonic.ai, and greenmask compared, plus how to roll your own when no tool fits.
- [BigQuery Dynamic Data Masking](/blog/bigquery-dynamic-data-masking.md): Compare BigQuery data masking options: native column-level dynamic data masking (built-in masking rules via policy tags and data policies, Dataplex catalog) and Bytebase fleet-wide masking.
- [SQL Server Dynamic Data Masking](/blog/sql-server-dynamic-data-masking.md): Compare SQL Server data masking options, native Dynamic Data Masking (five mask types, SQL Server 2022 granular UNMASK) and Bytebase fleet-wide masking.
- [Postgres Dynamic Data Masking](/blog/postgres-dynamic-data-masking.md): Compare PostgreSQL data masking options — PostgreSQL Anonymizer 2.0 (Rust rewrite, five strategies, security labels) and Bytebase fleet-wide masking.
- [Oracle Dynamic Data Masking](/blog/oracle-dynamic-data-masking.md): Compare Oracle data masking options. Native Data Redaction (five function types via DBMS_REDACT, EXEMPT REDACTION POLICY) and Bytebase fleet-wide masking.
- [MySQL Dynamic Data Masking](/blog/mysql-dynamic-data-masking.md): Compare MySQL and MariaDB data masking — 9.7 Enterprise DDM, the legacy plugin, Percona, MariaDB MaxScale's proxy filter, and Bytebase fleet-wide masking.
- [How to Handle Database Migration / Schema Change?](/blog/how-to-handle-database-schema-change.md): You add a column. The migration locks a 200M-row table for forty minutes. Here's the lane that keeps planned schema change from breaking prod.
- [How to Handle Ad-hoc Database Data Changes?](/blog/how-to-handle-adhoc-database-data-change.md): You write a one-line UPDATE against production. Here's the lane that keeps it safe: the four phases, the controls, and what each one prevents.
- [Database Access Governance: Why It Matters and How to Get it Right](/blog/database-access-governance.md): Database access governance is a critical component of any organization's security strategy. By implementing the right tools and policies, you can protect sensitive data in your databases, ensure regulatory compliance, and maintain a secure and productive engineering environment.
- [Notes on the MySQL 9.7 LTS release](/blog/notes-on-mysql-9-7-lts-release.md): Notes on the MySQL 9.7 LTS release: Hypergraph Optimizer in Community, JSON Duality View DML, Group Replication observability, and Dynamic Data Masking for Enterprise.
- [Bytebase vs. Navicat: a side-by-side comparison for database management](/blog/bytebase-vs-navicat.md): When evaluating database management tools, Navicat and Bytebase represent two different philosophies: individual desktop productivity versus team collaboration and governance.
- [What is Database Access Control (DAC)?](/blog/what-is-database-access-control.md): Most DAC implementations stop at the connection. Real DAC operates at the statement and covers three vectors: machine, human, and AI agent.
- [Database Access Control (DAC) Best Practices](/blog/database-access-control-best-practices.md): Database access control practices that hold up in a SOC 2 audit: least privilege, separation of duties, just-in-time access, statement-level enforcement, and the common mistakes that get flagged.
- [From Schema as Code to Schema as Context](/blog/schema-as-code-to-schema-as-context.md): AI agents need more than DDL. The full database lifecycle codified (schema, dependencies, ownership, history) gives LLMs the context to query correctly.
- [Postgres vs. SQL Server: a Complete Comparison in 2026](/blog/postgres-vs-sqlserver.md): An extensive comparison between PostgreSQL 18 and SQL Server 2025 — features, architecture, query optimization, development workflow, pricing, and a decision framework for picking the right one in 2026.
- [How to Govern AI Agent Database Access](/blog/how-to-govern-ai-agent-access-to-enterprise-data.md): How to give AI agents governed access to your databases. Identity, authorization, query control, audit, and masking, applied to a new principal type.
- [Enterprise Text-to-SQL: Context, Evaluation, and Governance](/blog/enterprise-text-to-sql.md): Text-to-SQL is easy to demo and hard to run across shared databases. Here is what context, evaluation, and governance actually mean once real teams put it in production.
- [Securing Database Change: From Bastion to Integrated Platforms](/blog/top-database-change-management-tools.md): Bastion gates connections. ITSM gates approval. PAM gates credentials. Three layers, three tools, one gap at execution — and what an integrated platform replaces.
- [How to Build a CI/CD Pipeline for Database Schema Migration](/blog/how-to-build-cicd-pipeline-for-database-schema-migration.md): How a CI/CD pipeline for database schema migration works end-to-end. What it gates, what it leaves outside, and the tools that fit.
- [gh-ost vs pt-online-schema-change](/blog/gh-ost-vs-pt-online-schema-change.md): How gh-ost and pt-online-schema-change compare on architecture, cut-over, foreign keys, and runtime control — for teams choosing a MySQL online schema migration tool.
- [The 6 Levels of Database Automation](/blog/database-automation-levels.md): Six levels of database automation, named after the autonomous-driving framework. From L0 manual SQL to L5 self-healing — and where most teams plateau.
- [Top Open Source Sensitive Data Discovery Tools in 2026](/blog/top-open-source-sensitive-data-discovery-tools.md): A guide to open source sensitive data discovery tools, from NLP libraries like spaCy and Microsoft Presidio to multi-source scanners like Hawk-Eye and full metadata platforms like OpenMetadata.
- [Require Primary Key: A SQL Review Rule Explained](/blog/sql-review-rule-explained-require-primary-key.md): What the "Require Primary Key" SQL review rule checks, the production problems a missing primary key tends to cause, and the SQL to fix tables that don't have one.
- [Prohibit CASCADE: A SQL Review Rule Explained](/blog/sql-review-rule-explained-prohibit-cascade.md): Learn why CASCADE operations in SQL can lead to catastrophic data loss and how the "Prohibit CASCADE" review rule protects your production database.
- [Enforce NOT VALID in CHECK: A SQL Review Rule Explained](/blog/sql-review-rule-explained-enforce-not-valid-in-check.md): What the "Enforce NOT VALID in CHECK" SQL Review rule does, why adding a CHECK constraint can lock your table, and how the two-step NOT VALID approach avoids it.
- [SOC 2 Audit Log Requirements: Lessons From Our Own Audit](/blog/soc2-audit-logging.md): What SOC 2 compliance audits actually want from your database audit log: not 'logging enabled' but evidence your auditor will accept. Lessons from going through our own audit.
- [Is SQL Review Necessary? Real Talk From Developers](/blog/is-sql-review-necessary.md): Real talk on whether strict SQL review and schema conventions actually help — with answers from working developers and DBAs.
- [Database Audit Logging: Two Layers, One Trail](/blog/database-audit-logging.md): Database audit logging really has two layers: the infrastructure layer your cloud provider ships, and the workflow layer you have to build yourself. Here is what each one captures, and why an audit needs both.
- [How Bytebase Handles Audit Logging](/blog/bytebase-audit-logging.md): How Bytebase audits the workflow layer: every SQL, schema change, approval, and export tied to a real user identity, with structured exports for any SIEM.
- [What's New in PostgreSQL 18: A DBA's Perspective](/blog/what-is-new-in-postgres-18.md): PostgreSQL 18 features and what they change for running production databases.
- [What's New in PostgreSQL 18: A Developer's Perspective](/blog/what-is-new-in-postgres-18-for-developer.md): PostgreSQL 18 features that change how application developers write and ship code.
- [Top 7 Postgres GUI Clients to Command Postgres 2026](/blog/top-postgres-gui-client.md): A Postgres GUI client gives you a visual interface to query, design, and administer PostgreSQL — instead of doing everything from psql. Here are the 7 most useful in 2026, with the trade-offs that decide which one fits your workflow.
- [HIPAA Compliance](/blog/hipaa.md): Bytebase is HIPAA-compliant — independent verification that our administrative, physical, and technical safeguards meet the HIPAA Security Rule for handling Protected Health Information.
- [Top Open-Source Postgres Backup Solutions in 2026](/blog/top-open-source-postgres-backup-solution.md): Six open-source PostgreSQL backup tools compared for 2026, with the language, license, interface, and best-fit use case for each, plus a note on which ones are still maintained.
- [Bytebase vs. PAM: Why Database Teams Need More Than Privileged Access Management](/blog/bytebase-vs-pam.md): PAM tools gate the database connection. Databases also need SQL review, a schema change workflow, and per-statement approval. Here is where PAM stops and why most teams run it alongside Bytebase.
- [Bytebase vs. StrongDM: a side-by-side comparison for database access control and JIT](/blog/bytebase-vs-strongdm.md): Bytebase vs StrongDM in 2026: a side-by-side comparison for database just-in-time (JIT) access control, covering permission models, SQL review, data masking, approval flow, audit log, and pricing.
- [SQL Review: From Linting to Governance](/blog/sql-review-tool-for-devs.md): SQL review catches bad SQL before it hits the database. This guide covers the three layers (linting, semantic rules, and policy with approval) and compares the main SQL review tools.
- [Database Change Management for SOX Compliance](/blog/database-change-management-sox-compliance.md): A practical look at what SOX Section 404 expects from database changes: the four ITGC domains, the six questions auditors actually ask, and how to make compliance evidence a byproduct of your workflow.
- [Bytebase vs. Metabase: a side-by-side comparison for developer and data teams](/blog/bytebase-vs-metabase.md): Bytebase vs Metabase in 2026: a side-by-side comparison of database tooling for developer teams and data teams, covering pricing, features, SQL Review, change workflow, and BI.
- [Supabase vs. Firebase: a Complete Comparison in 2026](/blog/supabase-vs-firebase.md): Supabase vs. Firebase compared across database, auth, real-time, serverless functions, AI, local dev, self-hosting, and pricing — updated for 2026 with Firebase Data Connect, Supabase Branching, and the latest product shifts.
- [What is Database Change Management (DCM)?](/blog/what-is-database-change-management.md): Database Change Management (DCM) explained — definition, why it is hard, the ideal workflow, state-based vs change-based approaches, tool evaluation criteria, and how it fits into DevOps.
- [Bytebase vs. DBeaver: a side-by-side comparison for database management](/blog/bytebase-vs-dbeaver.md): Bytebase vs. DBeaver compared across product scope, supported databases, change workflow, access control, data masking, and pricing. Updated for Bytebase 3.16 and DBeaver 25.
- [Bytebase vs. CloudBeaver: a side-by-side comparison for web-based database management](/blog/bytebase-vs-cloudbeaver.md): Bytebase vs. CloudBeaver compared across product scope, supported databases, change review, access control, data masking, and pricing. Updated for Bytebase 3.16 and CloudBeaver 25.
- [Bytebase vs. Flyway: a side-by-side comparison for database schema migration](/blog/bytebase-vs-flyway.md): Bytebase vs. Flyway compared across migration workflow, SQL review, access control, pricing, and CI/CD. Updated for Flyway Desktop and Bytebase 3.16.
- [What is Dynamic Data Masking (DDM)](/blog/what-is-dynamic-data-masking.md): Dynamic Data Masking (DDM) protects sensitive data in real-time by dynamically altering the data returned to the application or user without changing the data at rest
- [Bytebase vs. Liquibase: a side-by-side comparison for database schema migration](/blog/bytebase-vs-liquibase.md): Bytebase vs. Liquibase compared across migration workflow, SQL review, access control, pricing, and CI/CD. Updated for Liquibase 5.0 Secure and Bytebase 3.16.
- [Bytebase vs. Atlas: a side-by-side comparison for database schema migration](/blog/bytebase-vs-atlas.md): A side-by-side look at Bytebase and Atlas for database schema migration: how each one approaches migrations, their CI/CD and access control, supported databases, and what they cost. Updated for Atlas v1.1 and Bytebase 3.16.
- [Neon vs. Supabase: Which One Should I Choose](/blog/neon-vs-supabase.md): Neon and Supabase are the 2 new generation Postgres service providers. This is an extensive comparison between Neon and Supabase on architecture, compatibility, agentic workload, developer workflow, scalability, integration, compliance, pricing and more.
- [HIPAA Data Security and Retention Requirements](/blog/hipaa-data-security-and-retention-requirements.md): This guide focuses on HIPAA compliance at the database layer, providing healthcare organizations and database teams with practical guidance for implementing HIPAA Security Rule requirements.
- [TRUNCATE vs DELETE in SQL: Differences Across PostgreSQL, MySQL, and SQL Server](/blog/truncate-vs-delete-sql.md): TRUNCATE and DELETE both remove rows, but they differ in speed, rollback behavior, and locking. Here is how each one behaves in PostgreSQL, MySQL, and SQL Server, and when to reach for which.
- [What is a Database Schema?](/blog/what-is-database-schema.md): A database schema defines the logical structure of your data: tables, columns, types, keys, and constraints. Learn how schemas work and evolve.
- [Database Design Patterns Every Developer Should Know](/blog/database-design-patterns.md): A practical walk through six database design patterns you will actually meet in production: normalization, star schema, EAV, polymorphic associations, multi-tenancy, and the anti-patterns worth avoiding.
- [Top 5 MySQL GUI Clients in 2026](/blog/top-mysql-gui-client.md): A comparison of the top 5 MySQL GUI clients in 2026: MySQL Workbench, DBeaver, TablePlus, Beekeeper Studio, and Navicat.
- [pgvector: How to Add Vector Search to PostgreSQL](/blog/pgvector.md): A practical walkthrough of pgvector: installing the extension, storing embeddings, writing similarity queries, building HNSW indexes, and knowing when plain PostgreSQL is enough.
- [Upsert in SQL: INSERT ON DUPLICATE KEY vs ON CONFLICT Explained](/blog/sql-upsert.md): How upsert works across MySQL, PostgreSQL, and SQL Server, with the syntax for each, the edge cases worth knowing before you ship, and how upserts interact with migrations.
- [How to Fix Slow MySQL Queries: A Practical Guide](/blog/how-to-fix-slow-mysql-queries.md): How to find and fix slow MySQL queries: reading the slow query log, using EXPLAIN, tuning indexes, and rewriting queries, with a worked example for each.
- [Convex vs Supabase: Which Backend Platform Should You Choose?](/blog/convex-vs-supabase.md): Convex and Supabase are both backend-in-a-box platforms, but built on different foundations. This post compares their architecture, real-time model, data model, schema management, and pricing to help you decide.
- [Database Blue-Green Deployment: A Practical Guide](/blog/database-blue-green-deployment.md): Blue-green deployment is easy when your servers are stateless. The trouble starts at the database. This guide walks through why database blue-green is hard and how to do it without corrupting your data.
- [Top 10 Data Management Tools in 2026](/blog/top-data-management-tools.md): A look at 10 data management tools developers and data engineers actually use in 2026: GUI clients, schema migration, pipelines, and analytics, with pricing for each.
- [Top Open-Source SQL Parsers in 2025](/blog/top-open-source-sql-parsers.md): SQL clients makes it safer and easier to manage databases. In this post, we are taking a look at open source SQL clients options for you to try in 2024.
- [Top SQL Server Monitoring Tools: Best SQL Performance Monitors in 2026](/blog/top-sql-server-monitoring-tools.md): Compare the best SQL Server monitoring tools for 2026 — free and paid. Includes SSMS built-in SQL monitors, open-source MSSQL monitoring tools (DBA Dash, SQLWATCH, Opserver), and commercial SQL performance monitoring solutions (Redgate, Datadog).
- [DynamoDB vs MongoDB: Which NoSQL Database Should You Choose? (2026)](/blog/dynamodb-vs-mongodb.md): DynamoDB vs MongoDB: compare AWS DynamoDB and MongoDB on data model, query capabilities, scalability, pricing, global distribution, and security. Includes use case recommendations and real-world examples.
- [DDL vs DML in SQL: What is Data Definition Language and Data Manipulation Language?](/blog/what-is-ddl-and-dml-in-sql-database.md): Learn the difference between DDL and DML in SQL databases. DDL (Data Definition Language) defines database structure with CREATE, ALTER, DROP. DML (Data Manipulation Language) manages data with SELECT, INSERT, UPDATE, DELETE. Includes examples and comparison table.
- [Supabase vs AWS: Feature and Pricing Comparison (2026)](/blog/supabase-vs-aws-pricing.md): Supabase pricing starts free. We break down real costs for Pro ($25/mo) and Team ($599/mo) plans, explain overages, and compare each service head-to-head with AWS.
- [Schema Change Detection and Notification: Why a Simple Column Rename Can Break Your Data Pipeline](/blog/schema-change-detection.md): A walk-through of how renaming a single column can quietly break an analytics pipeline, why it happens, and how schema change detection and notification help you catch it early.
- [Postgres Query Plan: How to Read and Fix Performance Issues](/blog/postgres-query-plan.md): How to read a Postgres query plan, spot the common performance problems, and fix them without breaking other queries.
- [Top 4 Terraform UI Tools 2026](/blog/top-terraform-ui-tools.md): Explore the leading Terraform UI tools of 2026 that enhance IaC workflows with visualization, collaboration, and governance features to streamline infrastructure management.
- [The Anatomy of Postgres Permission ERROR 42501](/blog/anatomy-of-postgres-error-42501.md): A walk through every layer of the Postgres permission system that can raise ERROR 42501, why each one fires, and how the behavior differs from MySQL.
- [Top Free, Open Source Kubernetes Dashboard in 2026](/blog/top-open-source-kubernetes-dashboard.md): Top open-source Kubernetes dashboard solutions include K9s, Lens, and KubeDashboard.
- [Top 4 Free Docker Desktop Alternatives 2026](/blog/top-docker-desktop-alternatives.md): Due to Docker's recent requirement for a paid subscription for professional use, people began searching for alternatives. Right alternatives for you will depend on your specific needs and requirements.
- [Postgres Logs Explained: A Practical Guide for Production](/blog/postgres-logs.md): A practical look at Postgres logs: what they record, how the logging collector works, which parameters actually matter in production, and the mistakes that turn logs into expensive noise.
- [Postgres 19 Feature Preview: 64-bit MultiXactOffset](/blog/postgres-19-feature-preview-64bit-multixactoffset.md): Postgres 19 widens MultiXactOffset to 64 bits, eliminating the hidden 4 billion member limit that caused catastrophic outages for high-concurrency workloads.
- [MySQL Schema Migration Best Practice](/blog/mysql-schema-migration-best-practice.md): How to run MySQL schema migrations without blocking queries or causing downtime, covering the MySQL-specific behaviors that bite in production and the tools that work around them.
- [Postgres 19 Feature Preview: Sequence Synchronization for Logical Replication](/blog/postgres-19-feature-preview-logical-replication-sequence.md): Postgres 19 introduces automatic sequence synchronization for logical replication, eliminating manual tracking and making major version upgrades and failover significantly easier.
- [Database Multi-Environment Deployments - The Challenges and Patterns](/blog/database-multi-environment-deployments.md): What multi-environment database deployment actually involves, the problems teams keep hitting, and the patterns (manual scripts vs GitOps) for handling them.
- [Postgres Audit Logging Guide](/blog/postgres-audit-logging.md): The practical ways to audit a PostgreSQL database, from native logging to triggers, logical replication, pgAudit, and Bytebase, with the trade-offs of each.
- [How to Migrate from Supabase to AWS](/blog/how-to-migrate-from-supabase-to-aws.md): A walkthrough of moving each Supabase piece (database, auth, storage, functions, realtime, networking) to its AWS counterpart, with a services-first order that keeps the final database cutover simple.
- [Postgres Transaction ID (XID) Wraparound](/blog/postgres-transaction-id-wraparound.md): A plain explanation of Postgres Transaction ID (XID) wraparound: what causes it, how to check how close you are, and what keeps it from taking your database offline.
- [How I Ship Features with Postgres](/blog/how-i-ship-features-with-postgres.md): A practical guide to shipping features with PostgreSQL, covering my day-to-day development workflow, the tools I actually use, and real-world examples
- [What is Postgres LATERAL JOIN?](/blog/postgres-lateral-join.md): What a Postgres LATERAL JOIN does, when to reach for one, and the patterns and gotchas you'll run into using it.
- [MySQL Online DDL: A Practical Guide](/blog/mysql-online-ddl.md): What MySQL Online DDL actually does, how its three algorithms (INSTANT, INPLACE, and COPY) differ, and the limitations to plan around before you run a schema change in production.
- [SQL Table Naming Dilemma: Singular vs. Plural](/blog/sql-table-naming-dilemma-singular-vs-plural.md): Should your tables be named user or users? This post walks through the trade-offs of singular vs. plural table naming, what the common stacks default to, and a set of conventions you can copy into your own handbook.
- [Snowflake Dynamic Data Masking (DDM) and Alternatives](/blog/snowflake-dynamic-data-masking-and-alternatives.md): Compare Snowflake Dynamic Data Masking with database views and Bytebase fleet-wide masking on edition gate, policy management, and audit trail.
- [Top Open-Source Postgres Auth Solutions in 2025](/blog/top-open-source-postgres-auth-solution.md): A look at the open-source ways to add authentication and authorization to a Postgres app in 2025, from all-in-one platforms to libraries, identity servers, and the minimalist JWT-to-RLS pattern, with a "best for" note on each.
- [Postgres Case Sensitivity Explained](/blog/postgres-case-sensitivity.md): How PostgreSQL handles case in identifiers and string values, where it bites, and the settings that keep your queries consistent and fast.
- [What is pg_database_owner in Postgres](/blog/what-is-pg-database-owner.md): What pg_database_owner does in Postgres, why it was added, and how to use it without hitting the "cannot have explicit members" error.
- [Which Postgres Operation causes a table rewrite](/blog/postgres-table-rewrite.md): A reference for which Postgres DDL operations rewrite the whole table (and take heavy locks) versus which ones are metadata-only, plus how to test it yourself before you run it in production.
- [Postgres Row-Level Security Footguns](/blog/postgres-row-level-security-footguns.md): A practical rundown of the Postgres Row-Level Security traps that quietly break performance or leak data, with the fix for each.
- [Postgres Rollback Explained](/blog/postgres-rollback.md): A walk through the three ways to roll back changes in Postgres: transactions and SAVEPOINT, Point-in-Time Recovery, and compensating DML, and when each one fits.
- [Postgres Schema Migration without Downtime](/blog/postgres-schema-migration-without-downtime.md): Learn how Postgres locks affect schema migrations and which DDL operations conflict with DML to achieve zero-downtime deployments.
- [gh-ost Limitations You Need to Know Before Production](/blog/gh-ost-limitations.md): The limitations and gotchas of gh-ost for online MySQL schema changes, and when to reach for something else instead.
- [How to Use Postgres CREATE INDEX CONCURRENTLY](/blog/postgres-create-index-concurrently.md): Learn how to use CREATE INDEX CONCURRENTLY in Postgres to build indexes without blocking writes. Pitfalls, safety checks, and performance tips.
- [Top Open Source GitOps Tools in 2025](/blog/top-open-source-gitops-tools.md): In this post, we are reviewing several open-source GitOps tools.
- [Database Security Lifecycle Management](/blog/database-security-lifecycle-management.md): Learn how Bytebase enables organizations to implement comprehensive Database Security Lifecycle Management, unifying security and operations from development to production.
- [Features I Wish Postgres Had but MySQL Already Has](/blog/features-i-wish-postgres-had-but-mysql-already-has.md): Areas where MySQL shines and Postgres falls short.
- [Features I Wish MySQL Had but Postgres Already Has](/blog/features-i-wish-mysql-had-but-postgres-already-has.md): Areas where PostgreSQL shines and MySQL falls short.
- [Postgres vs. MySQL: Online Index Creation](/blog/postgres-vs-mysql-online-index-creation.md): Compare the online index creation difference between Postgres and MySQL
- [SOC 2 Data Security and Retention Requirements](/blog/soc2-data-security-and-retention-requirements.md): SOC 2 Data Security and Retention Requirements for Database Systems and How Bytebase Helps
- [Postgres vs. MySQL: Indexing Options](/blog/postgres-vs-mysql-indexing-options.md): Compare the different indexing options between Postgres and MySQL
- [Postgres vs. MySQL: JSON Support](/blog/postgres-vs-mysql-json-support.md): Compare the JSON support difference between Postgres and MySQL
- [Postgres vs. MySQL: DDL Transaction Difference](/blog/postgres-vs-mysql-ddl-transaction.md): Compare the DDL transaction difference between Postgres and MySQL
- [DynamoDB vs. Cassandra: a Complete Comparison in 2025](/blog/dynamodb-vs-cassandra.md): An extensive comparison between DynamoDB and Cassandra on performance, usability, operability, ecosystem and more.
- [RDS vs. DynamoDB: a Complete Comparison in 2025](/blog/rds-vs-dynamodb.md): An extensive comparison between DynamoDB and MongoDB on performance, usability, operability, ecosystem and more.
- [AlloyDB vs. Cloud SQL: engineering guide to choose the right Google Cloud database for 2025](/blog/alloydb-vs-cloudsql.md): An engineering perspective to evaluate Google AlloyDB and Cloud SQL, and help you to choose the right Google Cloud database for 2025
- [AWS Aurora vs. RDS Pricing: A Detailed Comparison 2025](/blog/aws-aurora-vs-rds-pricing.md): A simple comparison of AWS Aurora versus RDS pricing in 2025, helping you understand key differences and choose the right database service for your needs and budget.
- [Top Open Source Infrastructure as Code (IaC) Security Tools in 2025](/blog/top-open-source-iac-security-tools.md): Infrastructure as Code security tools help organizations identify vulnerabilities and misconfigurations in their infrastructure definitions. This post explores the top open-source IaC security tools available in 2025.
- [Top Open Source Workflow Orchestration Tools in 2025](/blog/top-open-source-workflow-orchestration-tools.md): Workflow orchestration tools help coordinate tasks, handle errors, and monitor execution processes. In this post, we are taking a look at open source workflow orchestration options
- [Top 4 Open Source Kubernetes Cluster Management Tools in 2025](/blog/top-open-source-kubernetes-cluster-management-tools.md): A comprehensive guide to the best open-source Kubernetes cluster management tools in 2025, including Argo CD, Karmada, Sveltos, and Plural.
- [GitLab CI vs. GitHub Actions: a Complete Comparison in 2025](/blog/gitlab-ci-vs-github-actions.md): An extensive comparison between GitLab CI and GitHub Actions on features, performance, and more.
- [MongoDB vs MySQL: a Complete Comparison in 2025](/blog/mongodb-vs-mysql.md): An extensive comparison between MongoDB and MySQL on data model, query language, scalability, performance, and more.
- [MongoDB vs Redis: a Complete Comparison in 2025](/blog/mongodb-vs-redis.md): An extensive comparison between MongoDB and Redis on performance, usability, operability, ecosystem and more.
- [DynamoDB vs PostgreSQL: A Concise Comparison](/blog/dynamodb-vs-postgres.md): DynamoDB and PostgreSQL are both popular databases, but they are different. This post compares them based on their key differences, strengths, and ideal use cases.
- [Platform Engineering vs. DevOps: A Strategic Comparison in 2025](/blog/platform-engineering-vs-devops.md): A Strategic Comparison Between DevOps and Platform Engineering
- [MySQL Timeout Explained](/blog/mysql-timeout.md): Explain why MySQL provides a variety of timeout settings.
- [CockroachDB vs. Postgres: a Complete Comparison in 2025](/blog/cockroachdb-vs-postgres.md): An extensive comparison between CockroachDB and PostgreSQL on license, architecture, performance, scalability, compatibility, deployment options.
- [TiDB vs. MySQL: a Complete Comparison in 2025](/blog/tidb-vs-mysql.md): An extensive comparison between TiDB and MySQL on license, architecture, performance, scalability, online ddl, compatibility, deployment options.
- [Common Database Port Numbers in 2025](/blog/common-database-port.md): A comprehensive reference guide to standard port numbers used by popular database systems in 2025
- [SOC 2 Type 2 Certification](/blog/soc2-type2.md): Bytebase has obtained SOC 2 Type 2 certification.
- [Database Version Control Best Practice](/blog/database-version-control-best-practice.md): Database version control is the practice of managing and tracking changes to a database schema and its associated data over time. Why best practice matters? Mitigate risks, improve collaboration, and ensure data audibility.
- [Database Security Compliance](/blog/database-security-compliance.md): Database Security Compliance is a critical framework that not only mitigates legal and financial risks but also enhances overall data governance.
- [DevOps vs. DevSecOps: What's the Difference](/blog/devops-vs-devsecops.md): DevOps and DevSecOps are methodologies aimed at improving software development and delivery, but they differ in their focus and integration of security.
- [What is a Change Advisory Board (CAB)?](/blog/what-is-change-advisory-board.md): A comprehensive guide to Change Advisory Boards (CAB), including their purpose, limitations, popular tools, and best practices for database change management.
- [Top Free, Open Source Postgres Explain Tool to Analyze Database 2025](/blog/top-open-source-postgres-explain-tool.md): A comprehensive guide to the best free and open-source PostgreSQL EXPLAIN tools for query performance analysis, including built-in extensions, online visualizers, and integrated GUI solutions.
- [What is Production Database](/blog/what-is-production-database.md): Understanding production databases, their critical importance, common deletion mistakes, and best practices for safeguarding these essential systems.
- [TiDB vs. CockroachDB: the Distributed Clash between MySQL and PostgreSQL](/blog/tidb-vs-cockroachdb.md): An extensive comparison between TiDB and CockroachDB on license, architecture, compatibility, scalability
- [Multi-Tenant Database Architecture Patterns Explained](/blog/multi-tenant-database-architecture-patterns-explained.md): A deep dive into multi-tenant database architecture patterns, exploring pros and cons of shared vs. isolated models, and how to choose the right approach for your SaaS application.
- [Top 5 Open Source Terraform Tools for 2025](/blog/top-terraform-tools.md): In this post, we will review the top 5 open source Terraform tools for 2025.
- [Top 6 Open Source Infrastructure as Code (IaC) Tools 2025](/blog/top-infrastructure-as-code-iac-tools.md): Explore the top IaC solutions for 2025 that help DevOps and platform engineering teams implement infrastructure automation at scale.
- [ServiceNow and GitHub Integration for Database Change Automation](/blog/database-change-automation-github-servicenow-integration.md): How to integrate ServiceNow, GitHub with Bytebase to Automate Database Changes.
- [How to Become a Platform Engineer in 6 months?](/blog/how-to-become-platform-engineer.md): Roadmap to become a platform engineer.
- [How to Choose Database UUID?](/blog/how-to-choose-database-uuid.md): Pros and Cons between choosing uuidv1, uuidv4, uuidv7
- [Top 3 Free SQL Editors with Built-in AI](/blog/top-free-sql-editor-with-ai.md): SQL editor with built-in AI streamlines database management, making SQL development faster, more accurate, and accessible to users of all skill levels.
- [PostgreSQL SQL Review and Style Guide](/blog/postgres-sql-review-guide.md): An extensive list of PostgreSQL SQL Review and Style Guide.
- [Postgres vs. MongoDB: a Complete Comparison in 2025](/blog/postgres-vs-mongodb.md): An extensive comparison between Postgres and MongoDB on performance, reliability, scalability, usability, operability, ecosystem and more.
- [How to Pick Platform Engineering Tools in 2025 - Advanced Guide](/blog/platform-engineering-tools-advanced-guide.md): Introduce the advanced tools for platform engineering. Covering CD, security, workflow orchestration, database development workflow, and internal development portal.
- [How to Pick Platform Engineering Tools in 2025 - Essential Guide](/blog/platform-engineering-tools-essential-guide.md): Introduce the essential tools for platform engineering. Covering code hosting, CI/CD, observability, resource provisioning, and secret management.
- [OpenAI vs. DeepSeek: SSN Database Schema Design](/blog/openai-vs-deepseek-ssn-database-schema-design.md): How OpenAI and DeepSeek designs SSN database schema.
- [SOC 2 Type 1 Certification](/blog/soc2-type1.md): Bytebase has obtained SOC 2 Type 1 certification, which is a significant milestone for Bytebase's security and compliance efforts.
- [GitHub vs. GitLab: a Complete Comparison in 2025](/blog/github-vs-gitlab.md): An extensive comparison between GitHub and GitLab on history, deployment model, tech stack, repository management, code review, code search, ci/cd, security, project management, ai, pricing
- [Top DevSecOps Tools for 2025](/blog/top-devsecops-tool.md): DevSecOps tools empower teams to seamlessly integrate security into every phase of the software development lifecycle, fostering the adoption of DevSecOps practices.
- [Database Tools in 2024: A Year in Review](/blog/database-tool-review-2024.md): What happened in the database tooling landscape in 2024.
- [PlanetScale vs. Neon: the Continued Saga between MySQL and PostgreSQL](/blog/planetscale-vs-neon.md): An extensive comparison between PlanetScale and Neon on architecture, compatibility, developer workflow, scalability, operability, integration, compliance, pricing and more.
- [How We Built the SQL Autocomplete Framework with ANTLR4](/blog/sql-auto-complete.md): How Bytebase leverages ANTLR4 to build a framework to implement SQL autocomplete for different SQL dialects.
- [Database Security: Read, Write, and Admin Permission Levels](/blog/database-security-read-write-admin-permision-level.md): Explain the different database permission levels
- [Database Rollback: When Shit Hits the Fan](/blog/database-rollback.md): Explain database rollback and how to automate it
- [Bytebase 3.0 - DevSecOps for Database](/blog/bytebase-3-0.md): Database DevSecOps, maintain developer velocity without compromising data security
- [Database security vulnerabilities are the craziest](/blog/database-security-vulnerabilities-are-craziest.md): Some of the craziest database security vulnerabilities uncovered in DBAs' career
- [How to Choose between UUID and Auto Increment Integer / Serial as the Primary Key?](/blog/choose-primary-key-uuid-or-auto-increment.md): Pros and Cons between choosing UUID or auto increment integer / serial as the primary key for SQL database.
- [Why Managed Database Service is not Enough](/blog/why-managed-database-service-is-not-enough.md): Managed database service only addresses part of the puzzles
- [How We Improved Our SQL Parser Speed by 70x](/blog/how-we-improved-sql-parser-speed-70x.md): How we optimize the ANTLR's grammar to significantly increase the SQL parsing speed for SQL Server.
- [Hope Is Not a Strategy: Why Jira Falls Short for Database Change](/blog/use-jira-for-database-change.md): When team wants to enforce a process for database change management. A quick approach is to reuse their existing ITSM system such as Jira. Let's review how a typical Jira workflow looks like and its inherent limitations.
- [Bytebase Surpasses 10,000 Stars on GitHub](/blog/ten-thousands-github-stars.md): Bytebase just passed 10,000 stars on GitHub, thanks to our global community.
- [Features I wish PostgreSQL had as a developer](/blog/features-i-wish-postgres-had.md): A list of features I wish PostgreSQL had. It is mainly around improving development workflow and inspired by Git. While acquiring Git-like behavior is challenging in database because of the stateful nature.
- [Schema Migration Outage: Author or Reviewer's Fault?](/blog/schema-migration-outage-fault.md): When schema migration outage happens, who should be more responsible in order to prevent future incidents?
- [Snowflake CI/CD and DevOps Best Practice](/blog/snowflake-ci-cd-devops.md): Describe the current feature gap of Snowflake CI/CD story and present a solution
- [Top Database Security Tools](/blog/top-database-security-tools.md): This article explores leading database security tools designed to shield your data from varied risks.
- [How many DBAs should a company hire](/blog/how-many-dbas-should-a-company-hire.md): Discuss the DBAs HCs for companies of different sizes
- [All the Database Tools Bytebase Replaces](/blog/all-database-tools-bytebase-replaces.md): Bytebase is an all-in-one solution for database development lifecycle management. It replaces fragmented database tools and unifies the workflow in a single place.
- [Bytebase Has Partnered with Vettabase!](/blog/bytebase-vettabase.md): Bytebase is pleased to announce a partnership with Vettabase, an open source database services company with a focus on database automation.
- [Notes on the DORA 2023 State of DevOps Report](/blog/dora-state-of-devops-2023.md): DORA recently released its annual State of DevOps 2023 report. Bytebase is a Database CI/CD tool for DBAs and DevOps teams, and we are diving deep into the State of DevOps Report.
- [Bytebase Q3 2023 in Retrospect](/blog/2023-q3-retrospect.md): As Q3 2023 comes to an end, let's take a look back at what we've accomplished at Bytebase in the past three months.
- [Hacktoberfest 2023 with Bytebase](/blog/hacktoberfest-2023.md): Join us at the 10th year of Hacktoberfest celebrating open-source!
- [Announcing Partnership with GitLab to Automate Database Development](/blog/bytebase-gitlab-technology-partner.md): We are proud to announce the Technology Partnership with GitLab to provide developers with a smooth database development experience.
- [What is Snowflake Auto-Suspend and Auto-Resume?](/blog/what-is-snowflake-auto-suspend-auto-resume.md): Snowflake provides auto-suspend and auto-resume to help customers to save budget when the warehouse is inactive
- [Bytebase Crossed 1 Million Downloads](/blog/one-million-downloads.md): Bytebase just passed 1 million downloads, thanks to our customers and community users all over the world.
- [Snowflake Schema Change and CI/CD Best Practice](/blog/snowflake-schema-change.md): While Snowflake revolutionizes data management and analytics, effectively managing schema changes and tracking change history becomes increasingly crucial.
- [What is Database Schema Migration?](/blog/what-is-database-migration.md): Database schema migration involves modifying the structure of objects within relational databases, evolving their schema from the current state to a new desired state. The two main schema transformation strategies are migration-based migration and state-based migration.
- [Migrating Postgres: from Render to Neon](/blog/migrating-postgres-from-render-to-neon.md): How we migrate the SQL Chat database from Render to Neon.
- [Database Review 2022 and 2023 Prediction](/blog/database-review-2022.md): What happened in database industry in 2022.
- [Bytebase 2.0 - the GitLab for Database DevOps](/blog/bytebase-2-0.md): Pioneering Database Change Management and bring the GitLab/GitHub experience to database development
- [Bytebase Q1 2023 in Retrospect](/blog/2023-q1-retrospect.md): As Q1 2023 comes to an end, let's take a look back at what we've accomplished at Bytebase in the past three months.
- [Top 3 Free Tools to Start a Local Database Instance on Mac](/blog/free-tools-to-start-local-database-on-mac.md): To manually spin up several different kinds (and versions) of database instances for testing can be gruesome. Here are some free tools to help you start a local database instance on Mac.
- [SQL Chat - Chat with Your Database](/blog/sql-chat.md): Announcing SQL Chat, chat-based SQL Client for querying data and answering DB questions.
- [A (Non-Exhaustive) Summary of ChatGPT Enhanced Database Tools](/blog/chatgpt-enhanced-database-tools.md): We wonder if ChatGPT can help us in the field of database administration, and we dug deep into some toolings that have incorporated ChatGPT to make our life easier.
- [Introducing Single Sign-On in Bytebase](/blog/introducing-single-sign-on-in-bytebase.md): This article demonstrates the Single Sign-On (SSO) protocols supported by Bytebase. SSO allows users to log in once and access all authorized resources, improving security, user experience, and organizational flexibility.
- [Bytebase 1.12.1 Deep Dive](/blog/1-12-1-new-features.md): The second release of the 🐰  year, the version number was upgraded from 1.12.0 to 1.12.1, and although it was a minor upgrade (since no schema changes were involved), it still included 230 code commits
- [Announcing Partnership with GitHub to Automate Database Development](/blog/bytebase-github-technology-partner.md): We are proud to announce the Technology Partnership with GitHub to provide developers with a smooth database development experience.
- [Streamline Database Change Management for TiDB Cloud with Bytebase](/blog/streamline-database-change-management-for-tidb-cloud-with-bytebase.md): We are proud to announce our partnership with PingCAP, which will help developers and DBAs to more efficiently and safely manage the lifecycle of application database schemas.
- [Introducing Terraform Bytebase Provider](/blog/introducing-terraform-bytebase-provider.md): With Terraform Bytebase Provider, teams can codify Bytebase resource configurations, including environments, database instances, and roles via Terraform.
- [Bytebase 1.12.0 Deep Dive](/blog/1-12-0-new-features.md): First release of the Year of Rabbit 🐰 is out, the version number was upgraded from 1.11.0 to 1.12.0. - SQL Review Policy - Price Plan Update.
- [Bytebase 1.11.0 Deep Dive](/blog/1-11-0-new-features.md): We are thrilled to announce the first release launch of 2023, marking a new beginning for our product and our valued customers. The version number was upgraded from 1.10.0 to 1.11.0. - MongoDB - Schema Diagram - Schema Editor.
- [Introducing MongoDB Support in Bytebase](/blog/introducing-mongodb-support-in-bytebase.md): Bytebase 1.11.0 brings MongoDB support. This blog post walks you through managing MongoDB with Bytebase.
- [The SQL Editor for Developers and DBAs](/blog/the-sql-editor-for-developers-and-dbas.md): Introduce the new SQL Editor in Bytebase Console with six highlights - Admin mode, database-based access control, data masking, audit logs, collaborative sheets and easy to use.
- [Bytebase 1.10.0 Deep Dive](/blog/1-10-0-new-features.md): Last week, we released Bytebase 1.10.0. Let's take a deeper look into the new features - Audit Log - Terraform Provider to manage user roles in PostgreSQL - Support for large SQL files.
- [VCS Integrated Database CI/CD Workflow Best Practice](/blog/database-cicd-best-practice.md): If we can develop a complete Database CI/CD workflow, and break the wall between developers and DBAs, will it improve release efficiency?
- [Bytebase 1.9.1 Deep Dive](/blog/1-9-1-new-features.md): Last week, we released Bytebase 1.9.1. Let's take a deeper look into the new features - schema editor, mark issues as Need Attention, database access control, and data masking.
- [Bytebase 1.9.0 Deep Dive](/blog/1-9-0-new-features.md): Last week, we released Bytebase 1.9.0. Let's take a deeper look into the new features - Sync Schema for PostgreSQL, SQL Editor Admin Mode, and External Approval via Feishu.
- [How schema sync works in Bytebase](/blog/how-schema-sync-work.md): Technical details about how Bytebase implements schema synchronization for MySQL.
- [Bytebase 1.8.0 New Features Dive](/blog/1-8-0-new-features.md): Last week, we released Bytebase 1.8.0. Let's take a deeper look into the new features - MySQL Sync Schema, Admin Mode for SQL Editor, and External Approval via Feishu.
- [MotherDuck, from SQLite to the Docker for Data](/blog/motherduck-from-sqlite-to-the-docker-for-data.md): From the SQLite-insipred DuckDB to the real Snowflake challenger and the Docker for data.
- [CNCF Landscape includes Bytebase as the first-ever database CI/CD solution](/blog/cncf-landscape.md): Bytebase is now the first solution to be included in the CNCF Landscape that focuses solely on database CI/CD.
- [Global variable support in Nuxt](/blog/global-variable-support-in-nuxt.md): We recently introduced a global version variable in our Nuxt docs to ease the documentation update during release. This article describes how we implement this feature.
- [Hacktoberfest 2022 with Bytebase](/blog/hacktoberfest-2022.md): Bytebase is participating in Hacktoberfest 2022! Join the month long celebration of open source with us.
- [How to cross compile with CGO using GoReleaser and GitHub Actions](/blog/how-to-cross-compile-with-cgo-use-goreleaser-and-github-action.md): We meet some trouble using goreleaser and cgo at the same time. This blog tells how we found the best practices.
- [gh-ost Based Online Schema Migration for MySQL](/blog/gh-ost-based-online-schema-migration-for-mysql.md): Introduce gh-ost based online schema migration and how to perform an online schema migration without downtime in Bytebase.
- [Dev, SRE, Operations, DevOps - What’s the Difference?](/blog/dev-sre-ops-devops-difference.md): Explain and address the confusion between Developer (Dev), Site Reliability Engineer (SRE), (Operations) Ops and DevOps.
- [Introducing Schema Review Policy for MySQL](/blog/schema-review-policy-mysql.md): This post introduces a new feature - schema review policy, which help DBAs and application developers compose better schema change statements.
- [The Database as Code Landscape](/blog/database-as-code-landscape.md): The idea of codifying database schema changes (aka schema migration) is not new. While we are observing an accelerated trend of embracing Database as Code (DaC) across the industry. In this blog, we will review the state-of-the-art in the Database as Code landscape and share our own insight into the current and future trends in this space.
- [DBA, Database and Developer - The Decameron](/blog/dba-database-developer-decameron.md): This is the first of the DDD series, consisting of 10 stories of DBA & Database & developer.
- [How Bytebase uses Render](/blog/how-bytebase-uses-render.md): We recently moved most of our hosted service to render.com and also leverage its unique capability to improve our dev workflow. I was responsible for this task.
- [How to build a highly-available service in the Cloud?](/blog/how-do-we-build-a-highly-available-service-in-the-cloud.md): This article describes how sharding can help building a highly-available services in the Cloud based on author's years of experience at Google Cloud.
- [Database Review 2021 and 2022 Prediction](/blog/database-review-2021.md): What happened in database industry in 2021. OLAP (Snowflake, Databricks, ClickHouse, Firebolt, ClickHouse), OLTP (PostgreSQL, PlanetScale, SQLite) and open source.
- [Database as Code - the Good, the Bad and the Ugly](/blog/database-as-code.md): Database-as-Code has many benefits in today's DevOps world. However, there exists several missing bricks preventing its wider adoption. We touch many points around Database-as-Code and also explain why Bytebase could help the transition.
- [Announcing Bytebase. Open-source database schema change and version control tool for Developers and DBAs](/blog/announce-bytebase.md): Bytebase is a tool for database schema change and version control, its main audience are Developers and DBAs. We want to make Bytebase the industry benchmark solution for managing database schema change.

## Reference Documentation

### Sqlserver

- [How to RENAME a column in SQL Server](/reference/sqlserver/how-to/how-to-rename-column-sqlserver.md)
- [ERROR 18456: Login Failed for User in SQL Server](/reference/sqlserver/error/18456-login-failed-for-user.md)

### Spanner

- [How to Find Project ID and Instance ID in Spanner](/reference/spanner/how-to/how-to-find-project-id-and-instance-id-spanner.md): Instructions on how to find project ID and instance ID of a Spanner instance
- [How to Create a Service Account in Spanner](/reference/spanner/how-to/how-to-create-a-service-account-spanner.md)

### Postgres

- [Top psql commands with examples](/reference/postgres/how-to/top-psql-commands-with-examples.md)
- [Postgres security best practices](/reference/postgres/how-to/postgres-security-best-practices.md)
- [Postgres Row Level Security (RLS)](/reference/postgres/how-to/postgres-row-level-security.md)
- [PostgreSQL Default Password](/reference/postgres/how-to/postgres-default-password.md)
- [How to Use SERIAL in PostgreSQL](/reference/postgres/how-to/how-to-use-serial-postgres.md)
- [How to Use IDENTITY Columns in PostgreSQL](/reference/postgres/how-to/how-to-use-identity-column-postgres.md)
- [How to store time in PostgreSQL - using TIMESTAMPTZ](/reference/postgres/how-to/how-to-store-time-postgres.md)
- [How to show Postgres locks](/reference/postgres/how-to/how-to-show-postgres-locks.md)
- [How to Show and Kill Postgres Running Queries](/reference/postgres/how-to/how-to-show-and-kill-postgres-running-queries.md)
- [How to Migrate database from MySQL to PostgreSQL](/reference/postgres/how-to/how-to-migrate-database-from-mysql-to-postgres.md)
- [How to manage Postgres users and roles](/reference/postgres/how-to/how-to-manage-postgres-users-and-roles.md)
- [How to list tables in PostgreSQL](/reference/postgres/how-to/how-to-list-tables-postgres.md)
- [How to install Postgres using docker](/reference/postgres/how-to/how-to-install-postgres-using-docker.md)
- [How to install Local Postgres on Mac, Ubuntu, CentOS, or Windows](/reference/postgres/how-to/how-to-install-postgres-on-mac-ubuntu-centos-windows.md)
- [How to install pg_dump on your Mac, Ubuntu, CentOS, Windows](/reference/postgres/how-to/how-to-install-pgdump-on-mac-ubuntu-centos-windows.md)
- [How to enable pg_stat_statements in PostgreSQL](/reference/postgres/how-to/how-to-enable-pg-stat-statements-postgres.md)
- [How to enable auditing in PostgreSQL](/reference/postgres/how-to/how-to-enable-auditing-postgres.md)
- [How to CREATE VIEW in PostgreSQL](/reference/postgres/how-to/how-to-create-view-postgres.md)
- [How to CREATE TABLE in Postgres](/reference/postgres/how-to/how-to-create-table-postgres.md)
- [How to CREATE INDEX in Postgres](/reference/postgres/how-to/how-to-create-index-postgres.md)
- [How to CREATE INDEX on large table in PostgreSQL](/reference/postgres/how-to/how-to-create-index-on-large-table-postgres.md)
- [How to Configure PostgreSQL SSL Connection](/reference/postgres/how-to/how-to-configure-postgres-ssl-connection.md)
- [How to use COALESCE in PostgreSQL](/reference/postgres/how-to/how-to-coalesce-postgres.md)
- [How to check Postgres version](/reference/postgres/how-to/how-to-check-postgres-version.md)
- [How to ALTER TABLE in Postgres](/reference/postgres/how-to/how-to-alter-table-postgres.md)
- [How to ALTER large table in PostgreSQL](/reference/postgres/how-to/how-to-alter-large-table-postgres.md)
- [How to ALTER COLUMN TYPE in Postgres](/reference/postgres/how-to/how-to-alter-column-type-postgres.md)
- [How to add a CONSTRAINT in Postgres](/reference/postgres/how-to/how-to-add-constraint-postgres.md)
- [How to fix pg_restore "input file appears to be a text format dump. please use psql"](/reference/postgres/error/pgrestore-input-file-appears-to-be-a-text-format-dump.md)
- [How to fix pg_dump "aborting because of server version mismatch"](/reference/postgres/error/pgdump-aborting-because-of-server-version-mismatch.md)
- [ERROR: logical replication target relation is missing some replicated columns](/reference/postgres/error/logical-replication-target-relation-missing-replicated-columns.md)
- [ERROR: cannot delete from table because it does not have a replica identity and publishes deletes](/reference/postgres/error/cannot-delete-from-table-no-replica-identity.md)
- [ERROR: cannot change return type of existing function](/reference/postgres/error/cannot-change-return-type-of-existing-function.md)
- [ERROR: cannot change name of input parameter](/reference/postgres/error/cannot-change-name-of-input-parameter.md)
- [ERROR 57P01: Terminating Connection Due to Administrator Command in Postgres](/reference/postgres/error/57p01-admin-shutdown-postgres.md)
- [ERROR 55P03: Lock not available](/reference/postgres/error/55p03-lock-not-available.md)
- [ERROR 53300: Too many connections](/reference/postgres/error/53300-too-many-connections.md)
- [ERROR 42P21: Collation mismatch](/reference/postgres/error/42p21-collation-mismatch.md)
- [ERROR 42P07: Relation already exists in Postgres](/reference/postgres/error/42p07-relation-already-exists-postgres.md)
- [ERROR 42P01: Relation Does Not Exist in Postgres](/reference/postgres/error/42p01-undefined-table-postgres.md)
- [ERROR 42804: Column is of type X but expression is of type Y](/reference/postgres/error/42804-datatype-mismatch.md)
- [ERROR 42803: Column must appear in the GROUP BY clause or be used in an aggregate function](/reference/postgres/error/42803-column-must-appear-in-group-by-clause.md)
- [ERROR 42803: aggregate function calls cannot be nested](/reference/postgres/error/42803-aggregate-function-calls-cannot-be-nested.md)
- [ERROR 42703: Column Does Not Exist in Postgres](/reference/postgres/error/42703-undefined-column-postgres.md)
- [ERROR 42702: Column Reference Is Ambiguous in Postgres](/reference/postgres/error/42702-ambiguous-column-postgres.md)
- [ERROR 42601: Syntax Error in Postgres](/reference/postgres/error/42601-syntax-error-postgres.md)
- [ERROR 42501: Permission denied for table in Postgres](/reference/postgres/error/42501-permission-denied-for-table-postgres.md)
- [ERROR 42501: Permission denied to reassign objects in Postgres](/reference/postgres/error/42501-only-roles-with-privileges-of-role-may-reassign-objects.md)
- [ERROR 42501: Must be owner of table in Postgres](/reference/postgres/error/42501-must-be-owner-of-table-postgres.md)
- [ERROR 42501: Must be owner of schema in Postgres](/reference/postgres/error/42501-must-be-owner-of-schema-postgres.md)
- [ERROR 40P01: Deadlock detected](/reference/postgres/error/40p01-deadlock-detected.md)
- [ERROR 40001: Could Not Serialize Access in Postgres](/reference/postgres/error/40001-serialization-failure.md)
- [ERROR 2BP01: Cannot drop schema because objects depend on it](/reference/postgres/error/2bp01-dependent-objects-still-exist.md)
- [ERROR 2BP01: Cannot drop constraint used by foreign key in Postgres](/reference/postgres/error/2bp01-cannot-drop-constraint-used-by-foreign-key-constraint-postgres.md)
- [ERROR 2B000: Cannot drop role because objects depend on it](/reference/postgres/error/2b000-dependent-privilege-descriptors.md)
- [ERROR 28P01: Password Authentication Failed in Postgres](/reference/postgres/error/28p01-invalid-password-postgres.md)
- [ERROR 25P02: Current Transaction is Aborted in Postgres](/reference/postgres/error/25p02-current-transaction-is-aborted.md)
- [ERROR 23514: New row for relation violates check constraint](/reference/postgres/error/23514-check-constraint-violation.md)
- [ERROR 23505: Duplicate Key Value Violates Unique Constraint in Postgres](/reference/postgres/error/23505-duplicate-key-value.md)
- [ERROR 23503: Insert or update on table violates foreign key constraint](/reference/postgres/error/23503-foreign-key-violation.md)
- [ERROR 23502: Null Value in Column Violates Not-Null Constraint in Postgres](/reference/postgres/error/23502-null-value-violates-not-null-constraint.md)
- [ERROR 22P02: Invalid Input Syntax for Type in Postgres](/reference/postgres/error/22p02-invalid-input-syntax-postgres.md)
- [ERROR 22003: Numeric Value Out of Range in Postgres](/reference/postgres/error/22003-numeric-value-out-of-range.md)
- [ERROR 22001: String Data Right Truncation in Postgres](/reference/postgres/error/22001-string-data-right-truncation.md)

### Mysql

- [Top mysql commands with examples](/reference/mysql/how-to/top-mysql-commands-with-examples.md)
- [MySQL security best practices](/reference/mysql/how-to/mysql-security-best-practices.md)
- [How to use AUTO_INCREMENT in MySQL](/reference/mysql/how-to/how-to-use-auto-increment-mysql.md)
- [How to Show MySQL Process List and Kill Process](/reference/mysql/how-to/how-to-show-mysql-process-list-and-kill-process.md)
- [How to show MySQL locks in InnoDB](/reference/mysql/how-to/how-to-show-mysql-locks.md)
- [How to install MySQL using Docker](/reference/mysql/how-to/how-to-install-mysql-using-docker.md)
- [How to install MySQL Shell on your Mac](/reference/mysql/how-to/how-to-install-mysql-shell-on-macos.md)
- [How to install local MySQL on your Mac, Ubuntu, CentOS, Windows](/reference/mysql/how-to/how-to-install-mysql-on-mac-ubuntu-centos-windows.md)
- [How to install MySQL Client on Mac, Ubuntu, CentOS, Windows](/reference/mysql/how-to/how-to-install-mysql-client-on-mac-ubuntu-centos-windows.md)
- [How to enable slow query log in MySQL](/reference/mysql/how-to/how-to-enable-slow-query-log-mysql.md)
- [How to enable auditing in MySQL](/reference/mysql/how-to/how-to-enable-auditing-mysql.md)
- [How to CREATE VIEW in MySQL](/reference/mysql/how-to/how-to-create-view-mysql.md)
- [How to CREATE TABLE in MySQL](/reference/mysql/how-to/how-to-create-table-mysql.md)
- [How to CREATE INDEX on large table in MySQL](/reference/mysql/how-to/how-to-create-index-on-large-table-mysql.md)
- [How to CREATE INDEX in MySQL](/reference/mysql/how-to/how-to-create-index-mysql.md)
- [How to Create a Database in MySQL](/reference/mysql/how-to/how-to-create-database-mysql.md)
- [How to Configure MySQL SSL Connection](/reference/mysql/how-to/how-to-configure-mysql-ssl-connection.md)
- [How to ALTER TABLE in MySQL](/reference/mysql/how-to/how-to-alter-table-mysql.md)
- [How to ALTER large table in MySQL](/reference/mysql/how-to/how-to-alter-large-table-mysql.md)
- [How to ALTER COLUMN TYPE in MySQL](/reference/mysql/how-to/how-to-alter-column-type-mysql.md)
- [How to add a CONSTRAINT in MySQL](/reference/mysql/how-to/how-to-add-constraint-mysql.md)
- [ERROR 2013 (HY000): Lost connection to MySQL server during query](/reference/mysql/error/2013-lost-connection-mysql-server.md)
- [ERROR 2003 (HY000): Can't connect to MySQL server on '[host]'](/reference/mysql/error/2003-cant-connect-mysql-server.md)
- [How to fix ERROR 2002 (HY000): Can't connect to local MySQL server through socket](/reference/mysql/error/2002-cant-connect-local-mysql-server.md)
- [ERROR 1698 (28000): Access Denied for User 'root'@'localhost' in MySQL](/reference/mysql/error/1698-access-denied-for-user-auth-socket.md)
- [ERROR 1452 (23000): Cannot Add or Update a Child Row in MySQL](/reference/mysql/error/1452-cannot-add-child-row.md)
- [ERROR 1451 (23000): Cannot delete or update a parent row](/reference/mysql/error/1451-cannot-delete-parent-row.md)
- [ERROR 1406 (22001): Data Too Long for Column in MySQL](/reference/mysql/error/1406-data-too-long-for-column.md)
- [ERROR 1396 (HY000): Operation xxx failed for user](/reference/mysql/error/1396-operation-failed-for-user.md)
- [ERROR 1366 (HY000): Incorrect String Value in MySQL](/reference/mysql/error/1366-incorrect-string-value.md)
- [ERROR 1364 (HY000): Field Doesn't Have a Default Value in MySQL](/reference/mysql/error/1364-field-doesnt-have-a-default-value.md)
- [ERROR 1292: Truncated Incorrect Value in MySQL](/reference/mysql/error/1292-truncated-incorrect-value.md)
- [ERROR 1267 (HY000): Illegal Mix of Collations in MySQL](/reference/mysql/error/1267-illegal-mix-of-collations.md)
- [ERROR 1264 (22003): Out of Range Value for Column in MySQL](/reference/mysql/error/1264-out-of-range-value-for-column.md)
- [ERROR 1217 (23000): Cannot delete or update a parent row](/reference/mysql/error/1217-cannot-delete-parent-row.md)
- [How to fix Error 1216: Cannot add or update a child row: a foreign key constraint fails](/reference/mysql/error/1216-cannot-add-child-row.md)
- [ERROR 1215 (HY000): Cannot add foreign key constraint](/reference/mysql/error/1215-cannot-add-foreign-key.md)
- [ERROR 1213 (40001): Deadlock found when trying to get lock](/reference/mysql/error/1213-deadlock-found.md)
- [ERROR 1205 (HY000): Lock Wait Timeout Exceeded in MySQL](/reference/mysql/error/1205-lock-wait-timeout-exceeded.md)
- [ERROR 1175: You are using safe update mode](/reference/mysql/error/1175-using-safe-update-mode.md)
- [ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet'](/reference/mysql/error/1153-packet-bigger-than-max-allowed-packet.md)
- [ERROR 1146 (42S02): Table Doesn't Exist](/reference/mysql/error/1146-table-doesnt-exist.md)
- [ERROR 1142 (42000): Command denied to user](/reference/mysql/error/1142-command-denied-to-user.md)
- [ERROR 1130 (HY000): Host is not allowed to connect](/reference/mysql/error/1130-host-not-allowed-to-connect.md)
- [ERROR 1111 (HY000): Invalid use of group function](/reference/mysql/error/1111-invalid-use-of-group-function.md)
- [ERROR 1093 (HY000): Can't Specify Target Table for Update in FROM Clause in MySQL](/reference/mysql/error/1093-cant-specify-target-table.md)
- [ERROR 1071 (42000): Specified Key Was Too Long; Max Key Length Is 767 Bytes in MySQL](/reference/mysql/error/1071-specified-key-was-too-long.md)
- [ERROR 1064 (42000): You Have an Error in Your SQL Syntax](/reference/mysql/error/1064-syntax-error.md)
- [ERROR 1062 (23000): Duplicate Entry for Key in MySQL](/reference/mysql/error/1062-duplicate-entry.md)
- [ERROR 1055 (42000): SELECT list is not in GROUP BY clause and contains nonaggregated column; this is incompatible with sql_mode=only_full_group_by](/reference/mysql/error/1055-select-list-not-in-group-by.md)
- [How to Fix MySQL Error 1054: Unknown Column in 'field list'](/reference/mysql/error/1054-unknown-column-in-field-list.md)
- [ERROR 1049 (42000): Unknown Database](/reference/mysql/error/1049-unknown-database.md)
- [ERROR 1048: Column Cannot Be Null in MySQL](/reference/mysql/error/1048-column-cannot-be-null.md)
- [ERROR 1045 (42000): Access denied for user (using password: YES)](/reference/mysql/error/1045-access-denied-for-user-using-password.md)
- [ERROR 1044 (42000): Access denied for user to database](/reference/mysql/error/1044-access-denied-for-user-to-database.md)
- [ERROR 1410 (42000): You are not allowed to create a user with GRANT](/reference/mysql/error/1041-you-are-not-allowed-to-create-a-user-with-grant.md)
- [ERROR 1040 (HY000): Too Many Connections](/reference/mysql/error/1040-too-many-connections.md)

### Mongodb

- [How to install MongoDB using Docker](/reference/mongodb/how-to/how-to-install-mongodb-using-docker.md)
- [How to install Mongo Shell (mongosh) on Mac, Ubuntu, CentOS, Windows](/reference/mongodb/how-to/how-to-install-mongodb-shell-on-mac-ubuntu-centos-windows.md)
- [How to install local MongoDB on Mac, Ubuntu, CentOS, Windows](/reference/mongodb/how-to/how-to-install-mongodb-on-mac-ubuntu-centos-windows.md)
- [How to Configure MongoDB SSL Connection](/reference/mongodb/how-to/how-to-configure-mongodb-ssl-connection.md)

### Mariadb

- [How to install MariaDB using Docker](/reference/mariadb/how-to/how-to-install-mariadb-using-docker.md)
- [How to install local MariaDB on your Mac, Ubuntu, CentOS, Windows](/reference/mariadb/how-to/how-to-install-mariadb-on-mac-ubuntu-centos-windows.md)
- [How to install MariaDB Client on Mac, Ubuntu, CentOS, Windows](/reference/mariadb/how-to/how-to-install-mariadb-client-on-mac-ubuntu-centos-windows.md)
- [How to Configure MariaDB SSL Connection](/reference/mariadb/how-to/how-to-configure-mariadb-ssl-connection.md)

### Clickhouse

- [How to run ClickHouse with Docker and connect using MySQL client](/reference/clickhouse/how-to/how-to-run-clickhouse-with-docker-and-connect-using-mysql-client.md)
- [How to rename a table in ClickHouse](/reference/clickhouse/how-to/how-to-rename-a-table-clickhouse.md)
- [How to list tables from a database in ClickHouse](/reference/clickhouse/how-to/how-to-list-tables-from-a-database-clickhouse.md)
- [How to create a table in ClickHouse](/reference/clickhouse/how-to/how-to-create-a-table-clickhouse.md)
- [How to create a database in ClickHouse](/reference/clickhouse/how-to/how-to-create-a-database-clickhouse.md)
- [How to Configure ClickHouse SSL connection](/reference/clickhouse/how-to/how-to-configure-clickhouse-ssl-connection.md)