Welcome to SQLThunder

A flexible and performant, high-level SQL client for Python that simplifies database interactions across SQLite, MySQL, and PostgreSQL.

Documentation

• Installation
  • Requirements
  • Install via pip
  • Development install (editable + dev tools)
  • Verify your installation
  • Next Steps
• Quickstart
  • Step 1 — Write a config file
  • Step 2 — Connect to the database
  • Step 3 — Create table
  • Step 4 — Insert rows
  • Step 5 — Run a query
  • Step 6 — Use the CLI
  • Next Steps
• Configuration
  • General Structure
  • Supported Fields
  • SQLite Example
  • Basic MySQL Example
  • MySQL Example with SSL and Options
  • PostgreSQL Example with Advanced Options
  • Notes
  • Next Steps
• DBClient
  • Client Initialization
  • Connection Lifecycle
  • Using DBSession (Context Manager)
  • Public Methods Overview
  • Notes
• Querying
  • Overview
  • query — One-shot SELECT
  • query_batch — Parallelized Chunked SELECT
  • query_keyed — Key-based Chunked SELECT
  • Which Should I Use?
  • Logging and Error Handling
  • Testing and Debugging Tips
  • Next Steps
• Execution
  • Overview
  • execute — One-statement, One-transaction
  • execute_many — Bulk SQL in a Single Transaction
  • insert_many — Simplified Atomic Inserts
  • execute_batch — Threaded DML (Multi-transaction)
  • insert_batch — Threaded Bulk Insert
  • Summary: Atomic vs Threaded
  • Error Handling in Execution
  • Note
  • Next Steps
• CLI
  • Overview
  • query — Run a SELECT Query
  • insert — Insert from CSV or Excel
  • execute — Run a single DDL or DML
  • Global Flags
  • Error Handling
  • Next Steps
• Examples
  • Querying Data
  • Key-based Chunked Query
  • Offset-based Batch Query
  • Insert Data from Excel
  • Fast Insert (Threaded)
  • Run a DDL or DML Statement
  • Save Query Output to File
  • Save Failed Inserts to File
  • See Also
• API Reference
  • Client