Get a database

jwtBearerAuth

Nile Documentation

Nile - PostgreSQL re-engineered for B2B apps

Introduction

What is Nile

Run Locally

Getting started with Nile's Postgres platform locally with Docker

Architecture

Architecture of Nile Postgres

Testing

Integration testing with Nile's Postgres platform using Docker

Tenant Virtualization

Tenant Isolation

Tenant Management

Tenant Placement

Tenant Sharing

Generative AI

Generative AI & Embeddings

Vector Database

PG-Vector

Getting started with pgvector

Retrieval Augmented Generation (RAG)

Streaming

Streaming model responses to the client in real-time

RAG vs Finetune

When to use RAG and when to fine-tune a model

Introduction to Postgres

Create Table

Creating a table in Postgres

Indexes

Indexes in Postgres

Joins

Joins in Postgres

Views

Views in Postgres

Compatibility

Postgres Compatibility

AWS Bedrock

Cohere

Confluent Cloud

LlamaIndex

Modal

Netlify

Vercel

AWS Lambda

Serverless Multi-tenant Backend with AWS Lambda

NextAuth

NextAuth Authentication with Nile

Stripe

Build SaaS with paid subscriptions - using Nile and Stripe

Support

Lists all credentials that exist for a database. The id of the credential is
included in the response, but not the password. Passwords are provided only once,
at the time the credential is created, and are encrypted for storage.


Lists credentials for a database

Generates a new secure credential for a database. The generated password is
returned in the response, and is the only time the password is available in
plaintext. No request body is required."


Create a database credential

Lists all of the databases in a workspace.


List databases

Creates a database record in the control plane and triggers creation in the
target region. Database names must be less than 64 characters, and unique
within a workspace. Names may contain letters (lower or uppercase), numbers,
and underscores, and must begin with a letter or underscore.


Create a database

Marks a database as deleted and queues its data for deletion. The database will
no longer appear in your Nile dashboard. You will be able to connect to it and
operate on it while it is queued for deletion, but compute costs still apply.


Delete a database

Retrieve the list of available region identifiers for a workspace.
Identifiers are composed of a prefix indicating the underlying cloud provider
followed by a region name in that provider. For example `AWS_US_WEST_2` is
associated with the `us-west-2` region (Portland, OR) of AWS.


List available regions

Lists all developer invites in a workspace

List developer invites

Sends an email to another developer with a link that allows them to join the
workspace.


Invite a developer to a workspace

Deletes a previously issued invite

Returns information about the developer associated with the token provided,
including the workspaces and database ids the developer is authorized to access,
and the email address associated with the developer.


Identify developer details

Lists all workspaces that an authenticated developer is authorized to use.


List workspaces

Creates a workspace for the authenticated developer. A workspace slug is
generated from the workspace name and used as the workspace identifier.
Workspace slugs must be globally unique.
Generated slugs will only include ASCII characters. Spaces and non-ASCII
characters are replaced with hyphens.


Create a workspace

Get workspaces

List details about the developers authorized to access the workspace.


List developers with access to a workspace

Post oauth2token

Post partnersvercelwebhook

Handles Vercel-initiated SSO using the OIDC code exchange flow

Vercel SSO token exchange for a developer

Documentation

API Reference

Pricing

Templates

Discord

Get Started

Community

Explore Nile in 5 minutes with PSQL

NextJS

Build a B2B Application with Postgres and NextJS

Drizzle

Build AI-Native B2B application with Postgres and Drizzle ORM

Prisma

Build AI-Native B2B application with Postgres and Prisma

Python

Build AI-Native B2B application with Postgres and Python

Node

Build AI-Native B2B application with Postgres, NodeJS and React

SmartBooks AI

SmartBooks AI - Your Intelligent Accounting Partner

SmartSpend AI

SmartSpend AI - Set teams free from manual expenses

Feedback360 AI

Feedback360 AI - 360-Degree Feedback, Perfected with AI

HealthPilot

HealthPilot - Enhancing Patient Care with Intelligent Assistance

RecruitAI

RecruitAI - Smarter Hiring, Powered by AI

HRIntelli

HRIntelli - Magically Simplifying HR with AI

TaskPilot AI

TaskPilot AI - Your AI-Driven Guide to Seamless Task Management

SalesLeadPilot

SalesLeadPilot - AI-Driven Guidance for Superior Lead Management

LawPilot

LawPilot AI - AI That Thinks Like a Lawyer

SmartCampaign AI

SmartCampaign AI - Your AI-Driven Marketing Ally

SmartNotion AI

SmartNotion AI - Crafting Organized Thoughts with Artificial Intelligence

OnboardIQ

OnboardIQ - Transform Customer Onboarding with Insightful AI

CalendIQ

CalendIQ - Intelligent Calendar Management for Busy Lives

SmartLearn

SmartLearn: AI Intelligence for the Modern Classroom

Slack++

Slack++ - Built with AI to power work

SupplyAI

SupplyAI - AI-Powered Efficiency for Your Supply Chain

CustomerDesk AI

CustomerDesk AI - AI-Powered Efficiency for Your Supply Chain

AITravelMate

AITravelMate - your business trips managed by AI

KnowledgeAI

KnowledgeAI - PDF search assistant for your organization

Code Assistant

Autonomous Code Assistant - Code more, type less

Sales Insight

Sales Insight - AI-native, multi-tenant enterprise sales assistant

Task Genius

Task Genius - AI-native, multi-tenant enterprise task manager

Schema Migrations with Drizzle

Django

Schema Migrations with Django

Schema Migrations with Prisma

SQLAlchemy

Schema Migrations with SQLAlchemy

Cohere Embedding Models

DeepInfra

Embedding Models served by DeepInfra

Fireworks

Embedding Models served by Fireworks

Google

Google Embedding Models

Open AI

Open AI Embedding Models

Voyage

Voyage Embedding Models

Numeric

Numeric types in Postgres

Character

Character types in Postgres

Date and Time

Date and Time Types in Postgres

JSON

JSON in Postgres

Arrays

Array types in Postgres

DBeaver

Connecting to Postgres using DBeaver

PSQL

Connecting to Postgres using PSQL

databases

developers

users

workspaces

API Reference

vercel

Get a database

Authorizations

Path Parameters

Response