List databases
curl --request GET \
--url https://api.sequinstream.com/api/postgres_databases \
--header 'Authorization: Bearer <token>'import requests
url = "https://api.sequinstream.com/api/postgres_databases"
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', 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",
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"
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")
.header("Authorization", "Bearer <token>")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.sequinstream.com/api/postgres_databases")
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": "post**********", // Obfuscated by default
"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,
"username": "sequin_user"
}
// ... other databases
]
}
Postgres databases
List databases
Lists all Postgres database connections in your account.
GET
/
postgres_databases
List databases
curl --request GET \
--url https://api.sequinstream.com/api/postgres_databases \
--header 'Authorization: Bearer <token>'import requests
url = "https://api.sequinstream.com/api/postgres_databases"
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', 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",
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"
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")
.header("Authorization", "Bearer <token>")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.sequinstream.com/api/postgres_databases")
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": "post**********", // Obfuscated by default
"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,
"username": "sequin_user"
}
// ... other databases
]
}
Query parameters
Set to
true to include the database password in the response. Defaults to false, which obfuscates the password.Example request
curl
curl -X GET 'https://api.sequinstream.com/api/postgres_databases?show_sensitive=false' \
-H 'Authorization: Bearer YOUR_API_KEY' \
-H 'Content-Type: application/json'
Response
Returns a list of Postgres database objects.A list containing Postgres database objects.
Hide properties
Hide properties
The ID of the database connection.
The user-defined name for the database connection.
The hostname of the database server.
The port number for the database connection.
The name of the logical Postgres database to connect to.
The username for authenticating with the database.
The password for authenticating with the database. This will be obfuscated unless
show_sensitive=true is used.Indicates whether SSL is enabled for the connection.
Indicates whether the hostname resolves to an IPv6 address.
Indicates whether this database connection uses the Sequin local tunnel.
Database connection pool size (internal setting).
Database connection pool queue interval (internal setting).
Database connection pool queue target (internal setting).
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": "post**********", // Obfuscated by default
"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,
"username": "sequin_user"
}
// ... other databases
]
}
⌘I