Changelog

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.
• 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.
• 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.

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.

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.

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.

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. 😅

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:

• Schema-diff in Neon CLI commands — branches
• Schema diff feature documentation
• Schema diff tutorial

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.

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.

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.

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:

• Playing with Neon
• Connect Neon to your stack
• Branching workflows
• Getting ready for production

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

• Connect an Express application to Neon
• Build a Python App with Reflex and Neon

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.

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.

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.

Improved billing summary

To help you better understand how much your usage is costing in a given billing period, the Billing page now includes a summary detailing your expected costs for that month. This includes the monthly charge for your current plan, as well as any extra charges incurred that month due to peak usage.

All charges are pro-rated. If you upgraded your plan, you only pay the new plan’s rate, prorated from the date you started the new plan within the billing period. Similarly, extra charges are prorated based on the date when your peak usage required any extras. Please note that extra charges do not carry over into the new billing period.

Better copy-connection-to-clipboard action

It's the little things. Since connecting to your database is such an important first step, we've made it that much easier to grab your connection string and go. Previously, the copy-to-clipboard icon was always there, but now, it's explicit: Copy snippet. You can't miss it.

Fixes & improvements

• Auth0, Clerk, Okta, Sequin cards on the Integrations page in the Neon Console are now linked to our documentation for those platforms. Clicking on the Read button on the integration card opens a documentation drawer.
• Fixed an issue in the SQL Editor that caused it to display a Ready status on page load when the editor was not yet connected. The editor now displays a valid Connected or Ready to connect status.
• Fixed an issue that prevented the current endpoint status from displaying properly in the Neon Console.
• Fixed an issue that caused changes made in the Edit compute endpoint drawer accessed from the Monitoring widget to disappear after closing and reopening the drawer.
• Fixed an issue with the password reveal functionality in the Connection Details widget.

Custom Period Selector for the Monitoring Dashboard

You can now select a custom time period for viewing database metrics on the Monitoring page in the Neon Console. This feature gives you the flexibility of choosing exact start and end dates and times for your monitoring period, helping you with both short-term and long-term trend analysis. To try it out, go to the Monitoring page in the Neon Console and select Custom from the Other menu.

Export query results to CSV, JSON, and XLSX in the Neon SQL Editor

The Neon SQL Editor now supports exporting query results to CSV, JSON, and XLSX formats. Additionally, you can expand your query results view to the entire SQL Editor window. You can access buttons for both features from the bottom right corner of the SQL Editor page.

Fixes & improvements

• To make it even easier to try Neon, we've removed the First Name, Last Name, and Password confirmation fields from the Neon Sign Up page. If you're signing up for Neon with an email account, only an email address is required.
• Fixed an issue that prevented the current storage usage from being displayed when entering a new billing period, making it appear that storage usage was reset to zero.
• Adjusted the location of the Quickstart in the Neon Console and other minor improvements.
• Improved error information for HTTP fetch queries using the Neon serverless driver. For a log of the latest updates to Neon's serverless driver, you can also refer to the Neon serverless driver changelog.