Skip to content
| Marketplace
Sign in
Visual Studio Code>Data Science>RedLens Pro — Cost, Performance & Governance for Amazon RedshiftNew to Visual Studio Code? Get it now.
RedLens Pro — Cost, Performance & Governance for Amazon Redshift

RedLens Pro — Cost, Performance & Governance for Amazon Redshift

LenSQL

|
3 installs
| (0) | Free Trial
The paid half of RedLens: cost and performance advice, the Redshift console, AI grounded in your schema, and governance administration. Requires the free RedLens extension.
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

RedLens Pro

The paid half of RedLens, the Redshift-native SQL IDE for VS Code.

RedLens Pro requires the free RedLens extension. VS Code installs it for you as a dependency. RedLens Pro adds features to that extension — it is not a standalone product and does nothing on its own.

Every install starts with 14 days of full Pro. No credit card. No account. No sign-up. When the trial ends the Pro features lock and the free extension keeps working exactly as before.


What you get

Cost and performance advice

CloudWatch infrastructure metrics with the RPU cost of the window you are looking at, distkey/sortkey advice, skew, stale statistics, and AWS's own Advisor recommendations with the SQL it suggests.

CloudWatch metrics beside query activity, with compute-seconds, RPU-hours and the estimated cost of the selected window

Query and load monitoring

WLM queueing with the queries that are waiting and for how long, per-query RPU cost, and COPY errors decoded into the file, line, column and reason — instead of an error code you have to go look up.

Query and load monitoring: the WLM queue with queued and execution times, serverless RPU cost, and COPY errors decoded to file, line, column and reason

The Table Optimization Advisor

Distribution and sort key advice, skew, unsorted blocks and stale statistics — each with the SQL that fixes it, and AWS Advisor's own recommendations alongside.

Table Optimization Advisor showing skew, unsorted percentage and stale statistics with remedial SQL

The Redshift console, in the sidebar

Parameters with everything non-default first, network and encryption, snapshots and retention, maintenance, logging and audit delivery, scheduled actions, usage limits, events and reservations. Plus the aws CLI to pause, resize or reconfigure — generated for you to review, with what it interrupts, whether it can be undone, and how to verify it worked. RedLens never mutates your cluster.

AI grounded in your live schema

Natural language to SQL, plan explanation, query optimisation, error fixing, table description, and an @redlens chat participant. It runs on your own Copilot subscription — there is no AI service of ours in the path, and no API key to buy from us.

Governance administration

Generated user, role and datashare DDL for review, and "why can this person do that" — the transitive role resolution with the exact path that grants each privilege.

Migration and pipelines

Schema diff to migration DDL, row-level data diff, guided UNLOAD and COPY, and scheduled queries via EventBridge.


What is Pro, and what is already free

The free extension is a complete daily loop, not a demo. Pro is what saves money, prevents incidents and governs.

Free Pro
Connections — Data API · direct · SSH bastion · Demo Unlimited Unlimited
Schema explorer · SQL editor · autocomplete · linting ✓ ✓
Result grid — sort, filter, charts, transpose, grouping, inline edit, export ✓ ✓
Query history · saved queries · notebooks · visual query builder ✓ ✓
EXPLAIN visualizer with DS_BCAST/DS_DIST warnings ✓ ✓
Governance tree — datashares, users, roles, privileges ✓ ✓
Safety — read-only mode, production safeguard, PII-safe masking ✓ ✓
MCP server — list_*, execute_query (read-only), explain_query ✓ ✓
Performance Dashboard — CloudWatch metrics, RPU cost — ✓
Table Advisor — skew, stale stats, AWS Advisor recommendations + SQL — ✓
Query & Load Monitoring — WLM queueing, per-query cost, decoded COPY errors — ✓
Cluster view — parameters, network, snapshots, maintenance, limits, events Properties only All ten sections
Generated aws CLI for console actions · read-only IAM policy generator — ✓
Compare Schemas · Compare Table Data · Schedule Query — ✓
S3 UNLOAD / COPY wizards — ✓
Effective Access · RLS & masking policies · admin code-gen — ✓
AI — NL→SQL, explain, optimize, fix error, describe, @redlens chat — ✓
Advanced MCP tools — table health, query history, recommendations, write — ✓

Every safety feature is free and always will be — read-only mode, the production safeguard, transaction control and PII-safe masking. Charging for not leaking PII is not a position worth defending.

Our promise: nothing that ships Free ever moves to Pro. New Pro features are new features, never features you already had.

The free extension is open source under the MIT licence: https://github.com/redlens-io/redlens


Price, and what happens if you stop paying

Licences are per person, per year:

  • Buy RedLens Pro — $99/year
  • Buy Team seats — $79/seat/year, minimum five
  • Enterprise — on request.

Refunds: 14 days, no questions asked — on a purchase or on a renewal.

Cancelling is a button, in the customer portal, reachable from RedLens: Manage Licence without leaving the editor. No email to us, no notice period, and you keep Pro until the end of the term you paid for. Invoices, payment method, seats and machine activations are there too.

If a licence lapses, the Pro features lock and the free extension keeps working exactly as before — your connections, history, saved queries and notebooks are untouched. Free never expires and is never capped.

Full pricing and terms: https://lensql.dev/pricing

How the key reaches you

Purchase happens outside VS Code and outside the Marketplace. Your receipt arrives by email with an Access purchase button; the key is on the page it opens, under Benefit Grants, and in your account at any time. Run RedLens: Manage Licence, choose Enter a licence key and paste it — it is verified offline, on your machine.


Your data does not leave your machine

RedLens has no server. Your SQL, your results, your schemas, your credentials and your AWS traffic go directly between your machine and your own systems. Licence verification is offline against an Ed25519 public key embedded in the extension, so Pro works inside a private VPC with no internet egress.

Full terms: LICENSE.md, which governs RedLens Pro only — the free extension is MIT and is not covered by it.


Support

  • Customers: https://lensql.dev/support
  • Community questions about the free extension: https://github.com/redlens-io/redlens/issues
  • Contact us
  • Jobs
  • Privacy
  • Manage cookies
  • Terms of use
  • Trademarks
  • Your Privacy Choices
  • Consumer Health Privacy
© 2026 Microsoft