Skip to content
| Marketplace
Sign in
Visual Studio Code>Linters>CopyPreflight — repeatable PostgreSQL CSV checks (evaluation)New to Visual Studio Code? Get it now.
CopyPreflight — repeatable PostgreSQL CSV checks (evaluation)

CopyPreflight — repeatable PostgreSQL CSV checks (evaluation)

Preview

Ambivra

| (0) | Free
Reuse local CSV checks, prepare correction requests, and recheck customer deliveries in VS Code. Free evaluation.
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

CopyPreflight — reuse checks for the next customer CSV

Free evaluation. No checkout or automatic charge.

Receiving another CSV with the same layout? Check the supported rules, prepare a correction-request draft, and recheck the next delivery with saved settings in VS Code. Inputs stay local: no database connection, upload, AI call or telemetry is implemented by this extension.

One short example: find, explain, recheck

Create two local files with this synthetic content. Save them as UTF-8 without BOM. No production CSV or database access is needed.

example.sql:

CREATE TABLE delivery (id integer, note text, quantity bigint NOT NULL);

delivery.csv:

id,note,quantity
1,synthetic order,
  1. Install extension ambivra.copy-preflight, version 0.4.0. If an older local prototype with a different identifier is installed, uninstall it and reload first; both cannot register the same commands. An existing installation of ambivra.copy-preflight uses the same extension identifier for this update.
  2. Run CopyPreflight: Check CSV with CREATE TABLE. Select the CSV and SQL. Choose a header row, leave the NULL token empty, and choose no FORCE columns. Review the shown columns and choose Check CSV. The missing quantity produces one NOT_NULL diagnostic.
  3. Run CopyPreflight: Open Correction Request Draft. It opens an untitled Markdown draft with the problem's location and a fixed explanation. Review and edit it before sharing. It is not saved, copied or sent automatically.
  4. Change the CSV's last line to 1,synthetic order,2 in the editor. Run CopyPreflight: Recheck Last CSV. The supported checks now report valid with zero diagnostics. The extension does not save your CSV changes.
  5. Run CopyPreflight: Open Generated Profile and use the editor's normal Save As to save the JSON yourself. For another delivery, run Check Selected CSV with Profile and select that JSON. Check Another CSV with Current Settings reuses adopted settings for one explicitly selected file.

Try swapping the header to quantity,note,id: the header-enabled generated profile stops with HEADER_MISMATCH. It does not silently interpret the wrong column order. The original profile format still works; old profiles with header: true but no headerMatch: true only skip the header.

What changed from 0.1.0

  • Generate a profile from a supported, simple CREATE TABLE, with explicit choices for CSV header and NULL behavior.
  • Match header names and order when the generated/header-enabled profile is used.
  • Keep the adopted checks while editing and recheck the current CSV buffer.
  • Prepare a correction-request draft without cell values, file paths or schema names.
  • Reuse saved settings and check the next selected CSV.

The checker and draft still cover a narrow subset. A clean supported check does not certify business meaning or guarantee a successful database import.

Supported scope

Tested on Windows x64 with VS Code 1.89.1 and 1.143.1. The minimum editor API declaration is VS Code 1.89.0; this is not a claim of testing every version. Remote/virtual workspaces and UNC paths are unsupported. Mapped network drives are not independently identified.

Strict UTF-8 without BOM, comma CSV, doubled double-quote escaping, consistent line endings, embedded quoted newlines, text, int4, int8, NOT NULL, explicit NULL token, FORCE_NULL and FORCE_NOT_NULL. Quoted empty text and an unquoted NULL token remain distinct. Integer range checks retain precision.

SQL conversion accepts one simple definition with unquoted ASCII column names, text/integer/bigint and optional NOT NULL. It rejects unsupported constraints, types, comments, quoted identifiers and general database dumps; it does not drop them silently. Saved profiles remain available for the supported rules.

Limits: CSV 5 MiB; SQL/profile 64 KiB; 128 columns; 50,000 logical records including header; 100,000 physical lines; 65,536 UTF-16 units per field; 200 diagnostics. Malformed, unsupported or over-limit inputs stop as incomplete.

No automatic repair, arbitrary business rules, batch import, database connection, SQL execution, live-table state, foreign-key, trigger or permission checks. Editing, closing or externally changing/deleting the selected SQL/profile invalidates the adopted setup. Rechecks reread it before accepting a result.

Help improve a possible paid workflow

This version is free to evaluate under the evaluation permission. It is not open source and is not currently offered for sale.

If you repeatedly receive CSVs, optional public feedback can tell us: the version you tried, whether you completed a real useful check, whether you reused it for another delivery, where it was awkward, and whether you would choose a hypothetical future supported product at USD9/month before tax. That is price research, not an order or payment obligation. No savings, import success, paying customers or continuous support is claimed.

Issues expose your username and text. Do not post real CSVs, private schemas, credentials, personal or customer data. Use synthetic examples only. AI may assist replies. Support is best effort, with no response-time SLA.

The evidence/... references in the bundled THIRD_PARTY.md identify development-time comparison records. Those records are not bundled extension features or support resources.

Stop or recover

Clear diagnostics, uninstall the extension and reload VS Code to stop evaluating. Keep your CSV, SQL and profile files. A retained obsolete extension folder does not imply it is still registered. No automatic charge or silent paid conversion occurs. If an update fails, stop using it and use your existing checks; selecting an older version is a user-controlled recovery option, with its documented scope.

  • Contact us
  • Jobs
  • Privacy
  • Manage cookies
  • Terms of use
  • Trademarks
  • Your Privacy Choices
  • Consumer Health Privacy
© 2026 Microsoft