Use Neon as your dev environment for AWS RDS: accelerate your workflow while reducing costs

Changelog

The latest product updates from Neon

RSS feed

Clearer language around compute types

Words matter. We've changed our naming convention around compute types: from RW compute and RO Replica to a cleaner, more straightforward Primary compute and Read replica.

new naming for compute types

With Neon's unique architecture, where we separate storage from compute for copy-on-write branching, you can choose the size and features for the compute that powers your branch's database independently from your data.

  • Primary compute — You don't have to add a compute to your branch right away, but once you decide to connect to your database, you need a Primary compute. Think of your primary compute as the engine that runs your branch. By adding a primary compute, you are in essence turning your branch "on". By default, your primary compute is read-write, though you can modify database permissions using traditional Postgres roles.
  • Read replicas — When you're ready to scale your application, you can offload read-only traffic to one or more read replicas. In Neon, read replicas work differently than traditional systems because the data is not physically replicated. Primary computes and read replicas work from the same data — a single, cost-effective source of truth.

For more information, see:

Fixes & improvements
  • The new create-app command in the Neon CLI is maturing fast: - It now supports Prisma as another ORM option for your bootstrapped application. - It also now creates two separate branches for your app's Neon project: your main branch and a development branch.

    create-app branches

Select the right compute size with predefined compute configurations

We've updated the Edit compute and Add new compute drawers in the Neon Console to include predefined compute configurations. With recommended min and max autoscaling settings and autosuspend timeout periods, these configurations make it easier to select the right compute size for your needs.

Compute configurations

Computes with more vCPU and memory

We've added support for larger computes with more vCPU and memory. If you're a Neon Scale plan user, you can now scale your computes up to 9 vCPU with 36 GB of RAM or 10 vCPU with 40 GB of RAM.

Larger compute sizes

More branch protection

If you've been following along, you know that we recently added safeguards to prevent you from deleting protected branches. This week, we're extended that protection:

  • You can no longer delete a Neon project that has protected branches.
  • You can no longer delete computes that belong to protected branches.

The protected branches feature is available with the Neon Scale plan.

Hackable AI starter apps

AI app banner

We've published a new set of hackable, pre-built AI starter apps to help you get up and running with Postgres as your vector store. The set includes different types of AI applications, including:

  • AI chatbot
  • RAG chatbot
  • Semantic search
  • Hybrid search
  • Reverse image search
  • Chat with PDF

Clone an app and make it your own.

For more, check out our new Neon AI Starter Kit, where you'll find links to our starter apps, docs, and a collection of AI applications built with Neon.

Consider sharing your AI app on our #showcase channel on Discord. We'd love to see what you're building.

Fixes & improvements
  • In a Postgres primary-standby configuration, certain settings should be no smaller on a standby than on the primary in order to ensure that the standby does not run out of shared memory during recovery, as described in the PostgreSQL hot standby documentation. For Neon read replicas, it's no different. The same settings should be no smaller on a read replica compute (the "standby") than on the default read-write compute (the "primary"). For this reason, the following settings on read replica computes are now synchronized with the settings on the default read-write compute when the read replica compute is started:
    • max_connections
    • max_prepared_transactions
    • max_locks_per_transaction
    • max_wal_senders
    • max_worker_processes
  • Fixed the SQLAlchemy code snippet in the Connection Details widget in the Neon Console. The host variable was missing a comma.
  • We've made it even clearer in our error message that lets you know when you've exceeded the permitted number of concurrently active computes. Neon has a default limit of 20 concurrently active computes to protect your account from unintended usage. See connection errors for more information.
  • Fixed an issue with the List projects API that caused it to return an empty result set when including an org_id value.
  • Fixed an issue that caused the Create project page to be displayed if a Project page could not be shown due to an error. The Projects list page is now shown instead.
  • For Free Tier users, the Data Transfer metric in the Resources remaining widget on the Project Dashboard now shows 0 when the 5 GiB allowance is exceeded, indicating that the allowance has been fully used.
  • Console navigation was improved by carrying forward the branch and database selected on the Dashboard when navigating to other console pages.
  • Console themes (System, Light, Dark) are now set through the Profile menu in the Neon Console. The Theme page, previously accessible from the Settings page, has been removed.
  • Fixed an issue with the rum extension that caused an error when building a RUM index with a large amount of data.
  • Fixed an issue with project sharing where an existing Neon account could not access a shared project after changing their email address to the one the project was shared with.

Updates to the Neon CLI

We've added some terrific new features to our CLI:

  • Configurable compute sizing with -cu option, including support for autoscaling

    You can now set your compute size when creating a branch using the CLI. For a fixed compute size, use a single number (e.g., --cu 2). For autoscaling, specify a range with a dash (e.g., --cu 0.5-3).

    Example:

    neon branches add-compute main --cu 0.5-3

    Previously, compute size was determined by your default settings in the console. For more about branching via the CLI, see Neon CLI commands — branches.

  • Bootstrap new applications with Neon using the create-app command

    You can now scaffold applications using the CLI with the create-app command. Choose your package manager, framework, ORM, and authentication method, and go. Read the docs for details. This exciting new feature is just getting started. More to come!

Added polish to our Branches page

Branching is still a relatively new concept in the database world, and we want to make your experience with it as intuitive as possible. Here are our latest updates to the Branches page:

  • Made it easier to create child branches by adding a clear-as-day Create child branch button to the detailed Branches view. It's still an option under the Actions dropdown, but now you've got the can't-miss button too. added create child branch button
  • Easier navigation from your listed database on the Roles and databases tab to the Drizzle Studio-based Tables page, where you can explore and modify your data directly. The actions kebab also includes options to delete your database, as well as navigate to the SQL Editor, and we preserve your database selection as you travel. databases edit and new kebab
  • We've changed the metric displayed on the Branches page from active hours to the more helpful compute hours metric, giving you a better sense of how much compute resources a given branch is consuming. For more details about consumption metrics, see Usage metrics.

Even more protection

Last week, we introduced protection against accidentally deleting protected branches. This week, we've added more safeguards:

  • Resetting Protected Branches: We now prevent you from using Reset from parent on protected branches (often your production branch) unless you unprotect the branch first.

Fixes & improvements

  • Fixed a misleading item in our Quickstart, where we told you that your compute had already started while it was still in transition. Trying to connect in that state would fail. Now, when you see your compute has started, it is definitely started. You can grab your connection string and go.

  • The Neon CLI ip-allow command's --primary-only option was deprecated and replaced by a --protected-only option. Additionally, in the Neon API, the primary_branch_only option in the Create project and Update project methods was deprecated and replaced by the protected_branches_only option. The deprecated options will be removed in a future release.

    These are follow-up changes associated with the renaming of "primary branches" to "default branches" that we implemented recently and announced in the June 21, 2024 changelog.

Explore Postgres extensions from the Neon Console

Postgres extensions let you customize and extend your database's capabilities across a broad range of categories: from analytics and data transformation to full-text search and geospatial data processing, and more. Currently, Neon supports over 70 Postgres extensions.

You can now explore all of Neon's supported extensions directly from the console. We've added an Install Extensions section to the Quickstart, which you can open from the Neon Console sidebar.

Quickstart extensions

Click Install to view the required CREATE EXTENSION command, and click Docs to view the extension's documentation.

More protection for protected branches

To better safeguard your protected branches, we've disabled the Delete action for those branches.

Now, before deleting a protected branch, you have to change its status to unprotected.

The Protected branches feature is available with the Neon Scale plan.

Fixes & improvements

  • We now preserve your currently selected branch and database when you switch between the SQL Editor and Tables page in the Neon Console.
  • Added an Endpoint Inactive legend item to the CPU and Database Size charts on the Monitoring page in the Neon Console. This legend item highlights periods when the compute endpoint was suspended, indicating no available data for those times.
  • Moved the system status out of the notifications menu to a system status badge in the main page header, making it easier to check your status in the Neon Console at a glance.
  • Added a psql -h pg.neon.tech connection snippet to the Connection Details widget. Instead of supplying a connection string when connecting with psql, you can use psql -h pg.neon.tech at the command line to launch a browser-based authentication flow.
  • The notifications icon in the Neon Console page header is now highlighted when there's a new notification.
  • Added RAM and vCPU alerts to the Neon Console to let you know when you're getting close to your plan limits.
  • We deprecated the Neon CLI branches set-primary command, which is now replaced by the branches set-default command. This is a follow-up change associated with the renaming of "primary branches" to "default branches" that we implemented recently and announced in the June 21, 2024 changelog. Support for the branches set-primary command will be removed in a future release.
  • For Free Tier users with access to shared projects, clicking an Upgrade Plan link within the shared project now displays a modal directing the shared project user to contact the project owner.
  • The Neon CLI set-context command no longer saves the Neon branch ID to the context file. Branch IDs defined in existing context files remain supported for backward compatibility.
  • Fixed an issue in the Neon CLI that caused a branch_id configured in a context file (created with the Neon CLI set-context command) to be used when an unrelated project ID was specified explicitly in a Neon CLI command.
  • Fixed an issue that prevented creating a new branch in the Neon Console using a Safari browser when selecting a specific date and time as the branch creation point. The issue resulted in an Invalid Date error.
  • Fixed an issue in the Neon Console that caused the history retention setting for a shared project to differ from the project owner's history retention setting.
  • Fixed an issue in the Neon Vercel Integration to better handle errors reported for variables set by the integration that were already configured in Vercel. The issue caused preview deployment failures.
  • Fixed an issue on the RAM and CPU charts on the Monitoring page in the Neon Console. The vertical axis scale was not displayed properly.
  • For Free Tier accounts, we added a Data transfer usage metric to the Resources remaining widget on the Project Dashboard. The Neon Free Tier has a 5 GiB per month data transfer allowance.
  • Fixed an issue that caused an incorrect connection count limit to be displayed in a usage alert when a compute was in a suspended state.

The next act for the Neon platform

The Neon Product Team spent this week mapping the future state of our platform, focused on shipping faster with Postgres, and what it takes to get there.

We're excited about the big changes coming. While we want to keep some surprises under wraps, we'd like to share a few details here to let you know what to expect, and get any feedback you'd like to offer:

  • Full-stack developer workflows — We're building end-to-end developer workflows focused on your database needs. Things like data and schema migrations, CI/CD integrations, and more.
  • Complex data workflows — We're also building workflows to handle the more complex needs of managing data across multiple environments. Migrations, data anonymization, and staging deployments are a few examples. If you have ideas on what you'd like to see in these workflows, let us know on Discord.
  • Integrated developer applications — We're making plans to solve other hard problems in App DevX, which we'll share when the time is right. Stay tuned.

Join the Neon Early Access Program to be among the first to try these Neon features as they come online.

Did you know?

Neon supports passwordless connections via psql. Instead of supplying a connection string when connecting with psql, you can simply type psql -h pg.neon.tech to authenticate through a browser-based authentication flow.

Finer-grained history configuration

We've introduced finer-grained history retention settings for your Neon project. Neon retains a detailed history of changes for all branches, enabling features like point-in-time restore and time travel connections. However, this history also adds to storage usage. To give you greater control, you can now select from a broader range of preset retention periods down to the hour or set a custom value.

History retention settings

For more information about history retention and the features it supports, see Branch reset and restore.

Manage your billing info in the Neon Console

You can now update your billing information directly from the Billing page in the Neon Console. This includes details like your company name, billing address, and tax ID fields if applicable to your country or region. Previously, updating billing information required opening a support ticket.

Edit billing info page

Support for pgvector 0.7.2

Neon now supports pgvector version 0.7.2.

For the official list of updates, refer to the pgvector changelog.

If you installed this extension previously and want to upgrade to the latest version, please refer to Update an extension version for instructions.

Fixes & improvements

  • Each Neon project is initially created with a "root" branch. Previously, this branch was designated as "primary" by default. To simplify our terminology, we've renamed this designation from "primary" to "default." Where you previously saw primary in relation to branches in the Neon Console, you will now see default. In line with this change, we've added default attributes to the Neon API. These will eventually replace the deprecated primary attributes in response bodies for endpoints like Get branches and Get branch details. Additionally, we've introduced a new Set branch as default endpoint, which will replace the deprecated Set branch as primary endpoint. The deprecated attributes and endpoint will be removed in a future release.
  • Minimum autosuspend delay settings are now applied on a plan downgrade. Previously, the minimum allowable settings were not changed when downgrading from one Neon plan to another. For example, when downgrading from the Scale plan (with a minimum autosuspend delay of 1 minute) to the Launch plan, the minimum delay now automatically adjusts to 5 minutes, the default for the Launch plan.
  • For Free Tier users, the Usage widget on the Neon Project Dashboard has been renamed to Resources remaining. This widget now displays your remaining storage, compute time, and branch allowances for the current billing period, providing a quick overview of your available resources.
  • We fixed an issue in the Neon console where role names containing emoji characters were not displayed correctly. But maybe we shouldn't encourage this. 😅 Emoji roles

Improved automation with Schema Diff in the CLI

You can now integrate the Neon CLI’s schema-diff feature into your CI/CD pipelines, letting you compare schemas between branches at any point in their history — useful for making sure that only the intended schema changes are promoted, maintaining consistent and controlled deployments.

Get started by using the command in your terminal:

neonctl branches schema-diff [base-branch] [compare-source[@(timestamp|lsn)]]

For example, this command compares the current schema state between the main branch and the development branch dev/alex:

neonctl branches schema-diff main dev/alex

Sample output of the schema-diff command might look like this:

--- Database: sales	(Branch: br-long-forest-a5glnuu4)
+++ Database: sales	(Branch: br-lucky-shape-a5fgfymm)
@@ -26,9 +26,10 @@

CREATE TABLE public.product (
    id integer NOT NULL,
    name text NOT NULL,
-    price numeric NOT NULL
+    price numeric NOT NULL,
+    description text NOT NULL
);

This diff shows that a new column description has been added to the product table in the dev/alex branch (br-lucky-shape-a5fgfymm) compared to main (br-long-forest-a5glnuu4).

For more detailed usage and options, see:

Computes, roles, and databases moved to branch pages in the Neon Console

You can now find your branch's computes, roles, and databases on the branch page they belong to. This update better reflects the relationship of these objects to their specific branches in a Neon project.

new branches page

With this change, we also moved the compute endpoint delete option to the Edit compute endpoint drawer, which you can access by clicking Edit on the Computes tab.

For more information about how objects in a Neon project are organized and related, see Overview of the Neon object hierarchy.

Support for pgvector 0.7.1

Neon now supports pgvector version 0.7.1. This new version improves the performance of on-disk HNSW index builds.

For the official list of updates, refer to the pgvector changelog.

If you installed this extension previously and want to upgrade to the latest version, please refer to Update an extension version for instructions.

Integration with Outerbase

We are excited to announce that the Outerbase integration for Neon is now publicly available.

This integration enables you to instantly connect your Neon Postgres database to Outerbase’s Data Studio and invite your team members to view, edit, query, and visualize your data.

Outerbase’s AI integration takes this a step further by helping users perform complex SQL tasks using natural language, making data manipulation accessible even to those without advanced SQL knowledge.

Outerbase's' data visualization tools help you create concise and beautiful charts and dashboards, making it easier to present and interpret data.

Outerbase overview

To learn how to connect Outerbase to your Neon project, check out this guide.

Fixes & improvements

  • The Neon CLI now supports a --no-color global option, which you can use to decolorize CLI command output when using Neon CLI commands in your CI/CD pipelines.
  • Fixed an issue with the dynamic rate limiter at the Neon Proxy that caused excessive CPU consumption and prevented new connections from being accepted.
  • Added a Source column to the Branches widget on the Project Dashboard, which shows icons that indicate the creation source for the branch. For example, you are now able to see if the branch was created in Neon, via the Neon Vercel Integration, or through our Hasura integration.
  • Added missing units of measure to the legends for several charts on the Neon Monitoring page in the Neon Console.
  • Updated the Restore branch modal to include timezone information alongside the date and time of the selected restore point, providing clearer context for restore operations.

Create a Postgres database in seconds at pg.new

First, there was docs.new for instantly creating Google Docs. Then, repo.new made adding new GitHub repositories a breeze. Now, meet pg.new — your gateway to spinning up new Postgres databases in seconds. Simply visit pg.new and you'll be taken straight to the Create project page in the Neon Console, where you can set up your new Neon Postgres project.

pg.new page

Fixes & improvements

  • Added your current timezone to the Restore branch confirmation page, to make it a little easier to understand the timestamp you are restoring to.
  • Scale plan users can now view database metrics for the past 14 days on the Monitoring page in the Neon Console. To try it out, go to the Monitoring page and select the Last 14 days item from the Other menu. Previously, metrics could only be viewed for the past 7 days.
  • The Database size chart on the Monitoring page in the Neon Console now displays size information for up to 10 databases.
  • Adjusted the functioning of the Create support ticket modal in the Neon Console to avoid automatically selecting Branch and Compute field values when opening the modal.
  • Fixed an issue that prevented the Autosuspend delay option from being displayed on the Edit compute endpoint drawer in shared projects.
  • After the next time you log in to Neon Console, navigating to neon.tech will automatically route you to console.neon.tech.

What's new in docs?

We're excited to announce the addition of new Getting Started documentation. If you're new to Neon or want to explore its full range of features, start with these comprehensive guides:

In addition, we've released new Express and Reflex framework quickstarts:

Anonymize sensitive data with Neon and Neosync

We are excited to announce that Neon has partnered with Neosync to provide developers with a complete solution for branching Postgres databases with anonymized data. Neosync is an open-source platform that helps developers anonymize production data and sync it across their environments for a better developer experience.

Both Neon and Neosync offer generous free tiers. If you’re interested in trying it out, follow the steps in our Neosync guide to get started.

Join the Neon Early Access Program from the Neon Console

You can now join the Neon Early Access Program directly from the Neon Console to be among the first to try new Neon features. From your Profile menu, select Account Settings > Early Access, and submit your Discord username.

Early Access Program console

The benefits of joining include:

  • Exclusive early access: Get a first look at upcoming features before they go live.
  • Private community: Gain access to a dedicated Discord channel to connect with the Neon team and provide feedback to help shape what comes next.
  • Weekly insights: Receive updates on Neon's latest developments and future plans.

Fixes & improvements

  • Improved the text on the Billing page in the Neon Console to better explain compute usage and allowances for each of Neon's plans.
  • Added a Home button to the Neon login page to provide a means of navigating to the Neon website if that was the intended destination.
  • Updated the Drizzle Studio version that supports the Tables page in the Neon Console. The new version fixes a display issue for long BIGINT values.
  • Improved the design of Billing summary section on the Billing page in the Neon Console to make it easier to understand your current billing status.
  • Addressed an issue with the Neon Vercel Integration that prevented the automatic branch deletion feature from removing Neon branches after merging the corresponding Git branch.
  • Custom-built extension support is now an Enterprise plan feature only. Any custom-built extensions that we currently support are not affected by this change and will continue to be supported on your current plan.

Support for pgvector 0.7.0

Neon now supports pgvector version 0.7.0.

This new version adds the following features and enhancements:

  • New vector types: halfvec (up to 4,000 dimensions) and sparsevec (up to 1,000 non-zero elements)
  • Support for indexing bit type (up to 64,000 dimensions) for binary vectors
  • Support for quantizing vectors using the binary_quantize function
  • New distance functions: hamming_distance and jaccard_distance
  • HNSW indexing for L1 distance operations
  • Support for CPU dispatching for distance functions on Linux x86-64

For the official list of updates, refer to the pgvector changelog. For documentation related to these new capabilities, please see the pgvector readme.

For edge-case behavior differences noticed during our testing, please see Differences in behavior between pgvector 0.5.1 and 0.7.0.

If you installed this extension previously and want to upgrade to the latest version, please refer to Update an extension version for instructions.

Drizzle Studio in the Neon Console

We're excited to announce that the Tables page in the Neon Console, which lets you explore the tables and data in your Neon databases, is now powered by Drizzle Studio. This integration introduces several new capabilities to the Tables page, including the ability to add, update, and delete records, filter data, add or remove columns, drop or truncate tables, and export data in .json and .csv formats.

Tables page Drizzle integration

Postgres version updates

The Postgres versions supported by Neon have been updated to 14.12, 15.7, and 16.3, respectively.

Fixes & improvements

  • The Neon CLI connection-string command and the Neon API Get connection URI method now generate a connection URI with a postgresql:// scheme designator instead of the shorter postgres:// designator. While both scheme designators are valid, we found the longer version to be more widely supported.
  • Added validation for Autosuspend minimum settings. For setting details, see Autosuspend limits.
  • Added a Charges to date field to the Billing summary section of the Billing page.
  • You can now access the Edit compute endpoint modal from the Branches widget on the Dashboard by clicking the compute endpoint link.
  • Fixed an issue on the Branches page that prevented a new branch from being listed immediately after it was created.
  • Fixed a styling issue that prevented the "Forgot password?" link from being fully visible on the Neon sign-in page while in dark mode.
Edit this page
Was this page helpful?