How does Postgres.new work?

Postgres.new uses PGlite, a WebAssembly version of PostgreSQL that can run directly in the browser. Each database created spins up a new instance of PGlite, providing a fully-functional Postgres database.

Is Postgres.new mobile-friendly?

Currently, Postgres.new is in early Alpha and does not support mobile devices. The developers are actively working on mobile support for PGlite and recommend using a laptop or desktop in the meantime.

What AI capabilities does Postgres.new offer?

Postgres.new pairs PGlite with a large language model (currently GPT-4) to provide AI assistance. The AI has full access to interact with the database, allowing it to perform real DDL operations and generate ER diagrams based on actual database structures.

Can I deploy databases created with Postgres.new?

The developers are working on enabling read-only deployments of databases created with Postgres.new. This feature is expected to allow hosting PGLite databases in S3, providing a cost-effective solution for certain use cases.

What PostgreSQL extensions does Postgres.new support?

Postgres.new supports a large catalog of PostgreSQL extensions. Two notable extensions mentioned are pgvector for indexing and searching embeddings, and a new extension developed by ElectricSQL as a client for their sync engine.

Postgres.new

WebsiteFreemiumAI SQL Assistant AI Developer Tools AI Data Mining

Postgres.new is an in-browser PostgreSQL sandbox with AI assistance that allows users to instantly create and interact with PostgreSQL databases directly in their web browser.

Social & Email:

Visit Website

Advertise This Tool

https://postgres.new/

Overview
Analytics
Alternatives

Product Information

Updated:Dec 9, 2024

Postgres.new Monthly Traffic Trends

Postgres.new experienced a 29.4% decline in traffic, likely due to the PG_MEM malware targeting PostgreSQL databases with weak passwords, which may have affected user trust and security concerns. The recent out-of-cycle update and new PostgreSQL releases, while addressing regressions and introducing new features, did not appear to mitigate the decline.

View history traffic

What is Postgres.new

Postgres.new is an innovative web-based tool that provides users with a fully functional PostgreSQL database environment accessible directly through a web browser. It combines PGlite, a WebAssembly (WASM) version of PostgreSQL, with AI assistance powered by GPT-4 to offer a seamless and interactive database experience. This tool is designed to allow users to create, manipulate, and experiment with PostgreSQL databases without the need for local installation or setup, making it ideal for learning, testing, and prototyping database solutions.

Key Features of Postgres.new

Postgres.new is an in-browser PostgreSQL sandbox with AI assistance, currently in early alpha stage. It allows users to experiment with PostgreSQL directly in their web browser without needing to install or set up a database locally. The tool is being actively developed to include features like mobile support and integration with PGlite.

In-browser PostgreSQL environment: Provides a fully functional PostgreSQL sandbox accessible directly through a web browser.

AI assistance: Offers AI-powered help for users working with PostgreSQL queries and commands.

No installation required: Allows users to work with PostgreSQL without needing to download or install any software locally.

Use Cases of Postgres.new

Quick PostgreSQL prototyping: Developers can quickly test PostgreSQL queries and features without setting up a local environment.

Educational tool: Students and learners can practice PostgreSQL skills in an accessible, low-barrier environment.

Database design exploration: Database architects can rapidly prototype and test database designs using a live PostgreSQL environment.

Pros

Accessible from any device with a web browser

No setup or installation required

Includes AI assistance for added support

Cons

Currently in early alpha stage with limited features

Lacks mobile support at present

May have limitations compared to a full local PostgreSQL installation

How to Use Postgres.new

Visit postgres.new in a web browser: Go to https://postgres.new in a desktop or laptop web browser. Mobile support is not yet available.

Wait for schema to load: The interface will display 'Loading schema...' initially. Wait for this process to complete.

Select a node: Press enter or space to select a node in the schema visualization.

Move nodes: Use the arrow keys to move the selected node around in the visualization.

Interact with AI assistant: Use the AI assistant paired with the database to help with queries and schema design.

Create and query tables: Use SQL commands or the AI assistant to create tables and run queries on your in-browser PostgreSQL database.

Use vector search capabilities: Leverage the built-in pgvector extension to create and query vector columns for AI/ML use cases.

View and copy generated SQL: Access the real SQL code generated from your interactions to use in other applications.

Postgres.new FAQs

Postgres.new is an in-browser PostgreSQL sandbox with AI assistance. It allows users to instantly spin up and interact with Postgres databases directly in their web browser.

Analytics of Postgres.new Website

Postgres.new Traffic & Rankings

68.9K

Monthly Visits

#602730

Global Rank

#1602

Category Rank

Traffic Trends: Aug 2024-Nov 2024

Postgres.new User Insights

00:01:26

Avg. Visit Duration

1.72

Pages Per Visit

63.27%

User Bounce Rate

Latest AI Tools Similar to Postgres.new

Data Nuts

FreeAI SQL Assistant AI Data Mining

DataNuts is a comprehensive data management and analytics solutions provider that specializes in healthcare solutions, cloud migration, and AI-powered database querying capabilities.

CogniKeep AI

PaidAI Data Mining AI SQL Assistant

CogniKeep AI is a private, enterprise-grade AI solution that enables organizations to deploy secure, customizable AI capabilities within their own infrastructure while maintaining complete data privacy and security.

Solaracloud.ai

Contact for PricingAI Knowledge Management AI SQL Assistant AI Data Mining

Solaracloud.ai is an AI-powered data empowerment platform that enables organizations to analyze, interpret and interact with their corporate data through natural language conversations while maintaining enterprise-grade security.

Chat2DB

FreemiumAI Code Generator AI SQL Assistant Multi-purpose Tools

Chat2DB is an AI-powered database management and analysis tool that enables users to interact with multiple databases using natural language, perform SQL operations, and generate visual reports through an intelligent interface.

Postgres.new