Your database, attended to.

Your queries, minded. Your cache, seen to. Your PostgreSQL, in good hands.
Three cache tiers, each maintained without a moment's concern on your part.
Simply point your connection string, and you shan't be troubled further.

87× swifter than the usual arrangements.

Get started See pricing →
* * *

The Redis Repertoire, avec Hors d'Oeuvres

Caching, pub/sub, queues, sessions, rate limiting, sorted sets, and Lua scripting — the capabilities teams have long relied on Redis to provide, now served directly from your PostgreSQL database. Twenty-one methods across seven language wrappers, each building upon what Redis pioneered with the addition of ACID guarantees, persistence by default, and the full power of SQL.

The Elasticsearch Arrangements, con Dolci

Full-text search, fuzzy matching, phonetic search, vector similarity, autocomplete, aggregations, reverse search, and relevance tuning — the capabilities teams have long relied on Elasticsearch to provide, now served directly from your PostgreSQL database. Thirteen methods across seven language wrappers, each building upon what Elasticsearch established with the addition of row-level security, SQL window functions, and transactional consistency.

The Pooling Provisions,
Built In

Connection pooling in session or transaction mode, read replica routing with read-after-write protection, automatic failover with health probes, and idle connection management for serverless providers — all built into the proxy. No separate pooler to deploy, no connection string gymnastics, no pool-size math.

* * *

Your queries, served in microseconds.

No cache code required.

The query 
SELECT
  c.segment, c.region,
  COUNT(DISTINCT o.id) AS orders,
  SUM(oi.quantity * oi.unit_price) AS revenue,
  AVG(oi.quantity * oi.unit_price) AS avg_order_value,
  STDDEV(oi.quantity * oi.unit_price) AS stddev_value,
  PERCENTILE_CONT(0.5) WITHIN GROUP
    (ORDER BY oi.quantity * oi.unit_price) AS median_value
FROM customers c
  JOIN orders o ON o.customer_id = c.id
  JOIN order_items oi ON oi.order_id = o.id
  JOIN products p ON p.id = oi.product_id
  JOIN categories cat ON cat.id = p.category_id
  JOIN payments pay ON pay.order_id = o.id
  JOIN shipping s ON s.order_id = o.id
  JOIN reviews r ON r.order_id = o.id
GROUP BY c.segment, c.region
ORDER BY revenue DESC;
With Gold Lapel
Before 12 seconds
After 4 microseconds

Benchmark: 8 tables · 1.3 million rows

* * *

What Gold Lapel handles

Expensive JOINs

Multi-table joins that take seconds, served in milliseconds. The results are pre-computed and kept fresh — your queries stay exactly the same, they just arrive faster.

SELECT * FROM orders
  JOIN users ON …
  JOIN products ON …

Missing Indexes

Slow filters and sorts, identified and fixed automatically. The right index for your actual query patterns, created without you lifting a finger.

SELECT * FROM events
WHERE status = 'active'
  AND created_at > …

Heavy GROUP BY

Dashboard queries that recompute on every page load, served instantly. The aggregation happens once — every subsequent request reads the answer directly.

SELECT region,
  SUM(total)
FROM orders
GROUP BY region

Slow Subqueries

Subqueries that re-execute for every row, replaced with instant lookups. The expensive work is done once and the results are ready when your query arrives.

SELECT * FROM users
WHERE id IN (
  SELECT user_id
  FROM orders …
)

Search

Search your data by meaning, by sound, or by any fragment of a string — all fast, all indexed automatically. No separate search engine to deploy, no data pipeline to keep in sync.

SELECT * FROM articles
WHERE to_tsvector('english', body)
  @@ to_tsquery('search terms')

Expensive CTEs

Reporting queries that rebuild the same intermediate results on every request. The heavy lifting is done once — your reports read from pre-computed answers.

WITH monthly AS (
  SELECT …
  FROM orders
  GROUP BY month
)
SELECT * FROM monthly …

N+1 Queries

The same query repeated fifty times in a single request — detected automatically, collapsed into one round-trip, and served from cache for the rest.

-- repeated per row:
SELECT * FROM authors
WHERE id = $1

Connection Pooling

Two hundred application connections, twenty database connections, zero configuration. Built into the proxy — nothing else to deploy or manage.

-- 200 app connections
-- 20 database connections
-- zero configuration

Read Replicas

Reads route to your replicas automatically. Writes go to the primary. Your application sees its own writes immediately, even while replicas catch up.

-- reads → replica
SELECT * FROM orders …
-- writes → primary
INSERT INTO orders …
* * *

Get started

Works the moment you arrive. A brief PostgreSQL preparation ensures nothing is left wanting.

Install 
pip install goldlapel
Connect 
# Sync
import goldlapel
conn = goldlapel.start("postgresql://user:pass@mycompany.com/mydb")

# Async
import goldlapel
conn = await goldlapel.start_async("postgresql://user:pass@mycompany.com/mydb")

Open your dashboard

Gold Lapel starts a real-time dashboard at localhost:7933 — five tabs of live metrics, query performance, cache status, and interactive settings.

Gold Lapel Dashboard
Explore the dashboard →
* * *

Pricing

30% off — WAITER30

14-day free trial. No credit card required.

Databases

How many databases will Gold Lapel optimize?

1

$39/mo each

Need SSO, SLA, or dedicated support?

The Waiter is at your service.

Contact Concierge

SQL Optimization

  • Automatic materialized views for repetitive JOINs, GROUP BY, aggregations, subqueries, and CTEs
  • Automatic indexes — B-tree, covering, GIN, HNSW, expression, and partial
  • Full-text search — automatic tsvector indexes so you can search your data without running Elasticsearch
  • Phonetic and fuzzy matching — typo-tolerant search that finds results by how words sound, not just exact spelling
  • Vector similarity search — automatic HNSW indexes for AI embeddings without a dedicated vector database
  • Transparent query rewriting and smart matview consolidation — no client changes needed
  • N+1 and deep pagination detection with fix suggestions
  • Shadow verification — tests correctness before routing traffic

Caching

  • L1 — native in-process cache (~2μs) inside the language wrapper, zero network hop
  • L2 — proxy-level in-memory cache (<1ms) shared across all connections
  • L3 — materialized views in PostgreSQL (<1ms), continuously refreshed, full SQL semantics
  • Automatic write-driven invalidation across all three tiers
  • Prepared statement cache (per-connection LRU)
  • Query coalescing — identical in-flight queries share a single result

Connection Management

  • Connection pooling (session or transaction mode)
  • Automatic read replica routing with read-after-write protection
  • Automatic failover to standby with health probes and recovery
  • TLS/SSL (client-facing and upstream)
  • Idle connection timeout — serverless-friendly (Neon, Aurora Serverless)

Observability

  • Live web dashboard with real-time metrics
  • "Show Your Work" audit timeline — every decision logged with reasoning
  • CLI tools: status, matviews, indexes, audit, config, clean
  • Comprehensive counters across all strategies

Safety

  • Bellhop mode — observation-only kill switch, flip without redeployment
  • Shadow mode — verifies correctness before routing
  • Read-after-write protection for replica routing
  • Table exclusion list and per-query skip annotation
  • Row-Level Security (RLS) policy preservation
  • goldlapel clean — remove all GL artifacts, leaving your database untouched

Configuration

  • Dashboard configuration tab — adjust settings visually from the browser
  • TOML config with goldlapel init generator
  • Hot-reload — change settings without restarting
  • Per-strategy enable/disable toggles
  • CLI flags, environment variables, or config file

Mesh Networking

  • Cross-instance cache invalidation — writes on one instance clear caches on all others
  • Encrypted peer-to-peer connections — works across regions, data centers, and cloud providers
  • Database-based peer discovery — no configuration needed
  • Remote dashboard access — view your dashboard from anywhere, no VPN required

Deployment

  • Single binary — Linux, macOS, Windows
  • Docker image (multi-arch)
  • Language wrappers: Python, Node, Ruby, Java, PHP, Go, .NET
  • Framework plugins: Django, Rails, Spring Boot, Laravel
  • ORM plugins: Prisma, SQLAlchemy, Drizzle
  • Self-update: goldlapel update

Enterprise

  • SSO / SAML authentication — integrate with Okta, Azure AD, Google Workspace (coming soon)
  • Compliance-ready audit exports — structured logs for SOC 2 and HIPAA workflows (coming soon)
  • Custom SLA with uptime guarantees
  • Priority support with dedicated account manager
  • Annual architecture review