# PostgreSQL Reference

PostgreSQL is an open source, object-relational database built for extensibility, data integrity, and speed. Its concurrency support makes it fully ACID-compliant, and it supports dynamic loading and catalog-driven operations to let users customize its data types, functions, and more.

## The DigitalOcean API

The [DigitalOcean API](https://docs.digitalocean.com/reference/index.html.md) lets you manage resources programmatically with standard HTTP requests. All actions available in the control panel are also available through the API.

By sending requests to the API’s `/v2/databases` endpoint, you can list, create, or delete database clusters as well as scale the size of a cluster, add or remove read-only replicas, and manage other configuration details.

See the [API documentation on databases](https://docs.digitalocean.com/reference/api/digitalocean/index.html.md#tag/Databases) for more information.

## The DigitalOcean Command Line Client, doctl

[`doctl`](https://github.com/digitalocean/doctl) is the command-line interface for the DigitalOcean API. It supports most of the same actions available in the API and DigitalOcean Control Panel.

[`doctl`](https://github.com/digitalocean/doctl) supports managing database clusters, database pools, replicas, and users, and more. Use `doctl databases help` for more information.

## The DigitalOcean MCP Server

The [DigitalOcean Model Context Protocol (MCP) server](https://docs.digitalocean.com/reference/mcp/index.html.md) lets you use natural language prompts to interact with DigitalOcean Managed Databases to create, resize, configure, migrate, and inspect clusters across all supported engines. All operations use argument-based input, and no resource URIs are used. The tools also support pagination, configuration management, firewall updates, user management, topic operations for Kafka, and other engine-specific settings where applicable.

## Official PostgreSQL Documentation

- The [PostgreSQL documentation](https://www.postgresql.org/docs/current/index.html)
- The [`psql` command-line client documentation](https://www.postgresql.org/docs/11/app-psql.html)