Get Started

Welcome to Bun Installation Quickstart TypeScript TypeScript 6 and 7

Watch Mode Debugging REPL bunfig.toml File Types Module Resolution JSX Auto-install Plugins File System Router

Cookies File I/O Streams Binary Data Archive SQL SQLite S3 Redis Workers Environment Variables Shell Spawn WebView Cron Node-API FFI C Compiler Transpiler CSRF Protection Secrets Console TOML YAML Markdown JSON5 JSONL HTMLRewriter Image Hashing Glob Semver Color Utils Globals Bun APIs Web APIs Node.js Compatibility

Standards & Compatibility

SQL

Bun provides native bindings for working with SQL databases through a unified Promise-based API that supports PostgreSQL, MySQL, and SQLite.

Archive

Create and extract tar archives with Bun's fast native implementation

SQLite

Bun natively implements a high-performance SQLite3 driver.

On this page

Features Database Support PostgreSQL MySQL SQLite Inserting data Bulk Insert Picking columns to insert Query Results sql``.values() format sql``.raw() format SQL Fragments Dynamic Table Names Conditional Queries Dynamic columns in updates Dynamic values and where in sql.array helper sql``.simple()Queries in files Unsafe Queries Execute and Cancelling Queries Database Environment Variables Automatic Database Detection MySQL Auto-Detection SQLite Auto-Detection PostgreSQL Auto-Detection MySQL Environment Variables PostgreSQL Environment Variables SQLite Environment Variables Runtime Preconnection Connection Options MySQL Options PostgreSQL Options SQLite Options Dynamic passwords SQLite-Specific Features Query Execution SQLite Pragmas Data Type Differences Transactions Basic Transactions Savepoints Distributed Transactions Authentication SSL Modes Overview Using With Connection Strings Connection Pooling Reserved Connections Prepared Statements Error Handling Error Classes PostgreSQL Connection Errors Authentication Errors Query Errors Data Type Errors Protocol Errors Transaction Errors SQLite-Specific Errors Numbers and BigInt BigInt Instead of Strings Roadmap Database-Specific Features Authentication Methods Prepared Statements & Performance Multiple Result Sets Character Sets & Collations Connection Attributes Type Handling Differences from PostgreSQL MySQL-Specific Features PostgreSQL-Specific Features Common Patterns & Best Practices Working with MySQL Result Sets MySQL Error Handling Performance Tips for MySQL Frequently Asked Questions Why not just use an existing library?Credits