neon-postgresGuides and best practices for working with Lakebase Postgres on Neon: connections, pooled vs direct, schema migrations, branching (including schema-only, reset-from-parent, and branch-per-PR workflows), autoscaling, scale-to-zero, instant restore, read replicas, IP allow lists, logical replication, egress optimization, and Lakebase Search. Use when the work is an existing DATABASE_URL, SQL, schema, inspect, or search. New backends, Auth, files, Functions, and LLM calls go to the parent `neon` skill. Live queries, reactive UIs, and realtime data go to `neon-realtime`. Also use for "@neondatabase/serverless", "@neon/neon-js", "neon inspect db", "neon postgres computes", "Neon branch", "schema-only branch", "reset branch", "branch per PR", high database bills, network transfer or egress, Free plan limits or a compute suspended over quota (SQLSTATE 53000, HTTP 402), SELECT * optimization, query overfetching, "semantic search", "vector search", "full-text search", "BM25", or "hybrid search".
Install via ClawdBot CLI:
clawdbot install andrelandgraf/neon-postgresGrade Fair — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Calls external URL not in known-safe list
https://neon.com/docs/introduction/branching.mdAudited Apr 16, 2026 · audit v1.0
Generated Mar 21, 2026
A startup developing a multi-tenant SaaS platform needs scalable, cost-effective database infrastructure with isolated environments for development, staging, and production. Neon's branching feature allows instant creation of isolated branches for feature testing and preview deployments, while autoscaling and scale-to-zero optimize costs during early growth phases.
An e-commerce company experiences fluctuating traffic, especially during holiday sales, requiring a database that can scale automatically without manual intervention. Neon's autoscaling adjusts compute resources based on demand, and its serverless architecture ensures high availability and performance during peak periods, with cost savings during off-seasons via scale-to-zero.
A financial services firm requires robust data recovery and point-in-time restore capabilities for compliance and risk management. Neon's instant restore feature allows creating branches from historical points-in-time, enabling quick recovery from data corruption or accidental deletions without traditional backup restore workflows.
An educational technology platform supports real-time collaborative tools and user authentication for students and instructors. Neon's integration with Neon Auth provides managed user authentication, while the Neon JS SDK offers PostgREST-style APIs for efficient data handling, and branching enables isolated environments for testing new features.
A healthcare application handles sensitive patient data with strict requirements for data isolation, security, and development environment management. Neon's branching allows for secure, isolated branches for different development stages, and its compatibility with Postgres ensures adherence to healthcare data standards, with scale-to-zero reducing costs for low-usage periods.
Neon's serverless architecture charges based on actual compute and storage usage, with scale-to-zero reducing costs during idle periods. This model is ideal for startups and small businesses with variable workloads, as it eliminates upfront infrastructure costs and aligns expenses with growth.
Neon offers tiered subscription plans (e.g., free, launch, scale) with varying limits on features like branching, autoscaling, and restore windows. This model caters to different business sizes, from hobbyists to enterprises, providing predictable pricing and access to advanced features as needs scale.
For large organizations with specific requirements, Neon provides custom enterprise solutions including dedicated support, enhanced security, and tailored SLAs. This model generates revenue through negotiated contracts, often including premium features like extended restore windows and higher compute limits.
💬 Integration Tip
Use the Neon CLI for local development and CI/CD automation, and refer to the connection methods guide to choose the right driver (e.g., serverless driver for edge runtimes) based on your application's constraints.
Scored Oct 21, 2026
Database Designer - POWERFUL Tier Skill
Skill Oracle — Curated documentation of quality ClawHub skills. Markdown tables telling agents which tools work and which are empty. Not an API or code library.
Database Schema Designer
Use when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis.
Pinecone vector database — manage indexes, upsert vectors, query similarity search, manage namespaces, and track collections via the Pinecone API. Build sema...
Connect, query, and monitor Redis instances. Use when checking key health, validating data types, generating backups, formatting results, linting configs.