Features

Everything Glider does to get your data into PostgreSQL.

Data Import

Glider reads a wide range of file formats and handles the messy details so you don't have to.

CSV & TSV

  • Auto-detects delimiters (comma, tab, pipe, semicolon)
  • Handles quoted fields and escaped characters
  • Streaming reader for large files

Excel

  • Supports .xlsx, .xls, and .ods
  • Date and time cell detection
  • Multi-sheet awareness

JSON & XML

  • Flattens nested JSON objects into tabular rows
  • Extracts repeating XML child elements as rows
  • Streaming parsing for large files

PDF & Parquet

  • Extracts tables from PDFs via column analysis
  • Parquet support with Snappy, LZ4, and Zstd compression

Intelligent Schema Inference

Glider examines every row of your data to detect the most appropriate PostgreSQL column types. Supported types include INTEGER, BIGINT, NUMERIC, BOOLEAN, DATE, TIMESTAMP, UUID, JSON, and TEXT. Each detection comes with a confidence score so you can verify the results.

Foreign Key Detection

When you upload multiple files, Glider automatically identifies relationships between tables. It uses naming conventions (like _id suffixes) and type compatibility to suggest foreign key constraints, each with a confidence score.

SQL Generation

Glider produces complete, dependency-ordered PostgreSQL SQL with fine-grained control.

DDL Options

  • CREATE TABLE with IF NOT EXISTS
  • DROP TABLE IF EXISTS option
  • Index creation on PK, unique, and FK columns
  • Schema namespace (default: public)

DML Options

  • Batched INSERT statements (configurable batch size)
  • Transaction wrapping (BEGIN/COMMIT)
  • Metadata comments with source file and row count
  • Streaming export for large datasets

Schema Editing

Before generating SQL, review and refine the inferred schema. Rename tables and columns, change column types, toggle nullable/unique/primary key constraints, set default values, and manage foreign key relationships — all from a visual editor.

Privacy & Security

Glider is offline by default. All data processing happens on your machine with no network requests during normal operation. There is no telemetry, no analytics, and no tracking. The Rust backend provides memory safety, and sensitive data like connection strings is zeroized from memory when no longer needed.

NEON PostgreSQL Integration

Optionally connect to a NEON PostgreSQL instance to test your connection and execute generated SQL directly. All connections require TLS — Glider rejects insecure SSL modes and only allows require, verify-ca, or verify-full.