Get database
curl --request GET \
--url https://api.sequinstream.com/api/postgres_databases/{id_or_name} \
--header 'Authorization: Bearer <token>'import requests
url = "https://api.sequinstream.com/api/postgres_databases/{id_or_name}"
headers = {"Authorization": "Bearer <token>"}
response = requests.get(url, headers=headers)
print(response.text)const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};
fetch('https://api.sequinstream.com/api/postgres_databases/{id_or_name}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.sequinstream.com/api/postgres_databases/{id_or_name}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://api.sequinstream.com/api/postgres_databases/{id_or_name}"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("Authorization", "Bearer <token>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://api.sequinstream.com/api/postgres_databases/{id_or_name}")
.header("Authorization", "Bearer <token>")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.sequinstream.com/api/postgres_databases/{id_or_name}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'
response = http.request(request)
puts response.read_body{
"data": {
"database": "sequin_prod",
"hostname": "db.abc123xyz.us-east-1.rds.amazonaws.com",
"id": "2593a3fc-9afe-4ea8-8ede-cffc8ae57c89",
"ipv6": false,
"name": "production_rds",
"password": "supersecret", // Not obfuscated because show_sensitive=true
"pool_size": 10,
"port": 5432,
"queue_interval": 1000,
"queue_target": 50,
"replication_slots": [
{
"publication_name": "sequin_pub",
"slot_name": "sequin_slot",
"status": "active"
}
],
"ssl": true,
"use_local_tunnel": false,
"username": "sequin_user"
}
}
{
"errors": {
"detail": "Postgres Database not found"
}
}
Postgres databases
Get database
Retrieve a Postgres connection by its ID or name.
GET
/
postgres_databases
/
{id_or_name}
Get database
curl --request GET \
--url https://api.sequinstream.com/api/postgres_databases/{id_or_name} \
--header 'Authorization: Bearer <token>'import requests
url = "https://api.sequinstream.com/api/postgres_databases/{id_or_name}"
headers = {"Authorization": "Bearer <token>"}
response = requests.get(url, headers=headers)
print(response.text)const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};
fetch('https://api.sequinstream.com/api/postgres_databases/{id_or_name}', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.sequinstream.com/api/postgres_databases/{id_or_name}",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://api.sequinstream.com/api/postgres_databases/{id_or_name}"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("Authorization", "Bearer <token>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://api.sequinstream.com/api/postgres_databases/{id_or_name}")
.header("Authorization", "Bearer <token>")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.sequinstream.com/api/postgres_databases/{id_or_name}")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'
response = http.request(request)
puts response.read_body{
"data": {
"database": "sequin_prod",
"hostname": "db.abc123xyz.us-east-1.rds.amazonaws.com",
"id": "2593a3fc-9afe-4ea8-8ede-cffc8ae57c89",
"ipv6": false,
"name": "production_rds",
"password": "supersecret", // Not obfuscated because show_sensitive=true
"pool_size": 10,
"port": 5432,
"queue_interval": 1000,
"queue_target": 50,
"replication_slots": [
{
"publication_name": "sequin_pub",
"slot_name": "sequin_slot",
"status": "active"
}
],
"ssl": true,
"use_local_tunnel": false,
"username": "sequin_user"
}
}
{
"errors": {
"detail": "Postgres Database not found"
}
}
Path parameters
string
required
The ID or name of the Postgres database connection.
Query parameters
boolean
default:"false"
Set to
true to include the database password in the response. Defaults to false, which obfuscates the password.Example request
curl Using Name
curl -X GET 'https://api.sequinstream.com/api/postgres_databases/production_rds?show_sensitive=true' \
-H 'Authorization: Bearer YOUR_API_KEY' \
-H 'Content-Type: application/json'
curl Using ID
curl -X GET 'https://api.sequinstream.com/api/postgres_databases/2593a3fc-9afe-4ea8-8ede-cffc8ae57c89' \
-H 'Authorization: Bearer YOUR_API_KEY' \
-H 'Content-Type: application/json'
Response
Returns a single Postgres database object.object
A Postgres database object.
Hide properties
Hide properties
string (uuid)
The ID of the database connection.
string
The user-defined name for the database connection.
string
The hostname of the database server.
integer
The port number for the database connection.
string
The name of the logical Postgres database to connect to.
string
The username for authenticating with the database.
string
The password for authenticating with the database. This will be obfuscated unless
show_sensitive=true is used.boolean
Indicates whether SSL is enabled for the connection.
boolean
Indicates whether the hostname resolves to an IPv6 address.
boolean
Indicates whether this database connection uses the Sequin local tunnel.
integer
Database connection pool size (internal setting).
integer
Database connection pool queue interval (internal setting).
integer
Database connection pool queue target (internal setting).
array
Details about the associated replication slot. Will be an empty array if no slot exists.
{
"data": {
"database": "sequin_prod",
"hostname": "db.abc123xyz.us-east-1.rds.amazonaws.com",
"id": "2593a3fc-9afe-4ea8-8ede-cffc8ae57c89",
"ipv6": false,
"name": "production_rds",
"password": "supersecret", // Not obfuscated because show_sensitive=true
"pool_size": 10,
"port": 5432,
"queue_interval": 1000,
"queue_target": 50,
"replication_slots": [
{
"publication_name": "sequin_pub",
"slot_name": "sequin_slot",
"status": "active"
}
],
"ssl": true,
"use_local_tunnel": false,
"username": "sequin_user"
}
}
{
"errors": {
"detail": "Postgres Database not found"
}
}
⌘I

