Amazon Lightsail

Amazon Lightsail Relational Databases API

The Relational Databases API from Amazon Lightsail — 22 operation(s) for relational databases.

GitHub OpenAPI
Business capability
IT Infrastructure Management BC-600.50

Operations 22

Each operation below carries the questions people ask an LLM about it and the instructions they give an agent to run it. Generated by API Evangelist overlay

POST /ls/api/2016-11-28/CreateRelationalDatabase Create a managed database · Creates a new database in Amazon Lightsail #
Ask an LLM
“How do I spin up a managed MySQL or PostgreSQL database in Lightsail?”
“Can I choose the backup and maintenance windows when creating a database?”
Tell an agent
Create database {relationalDatabaseName} with engine {relationalDatabaseBlueprintId} on plan {relationalDatabaseBundleId}.
Create a new managed database {relationalDatabaseName} in {availabilityZone} with public access {publiclyAccessible}.
POST /ls/api/2016-11-28/CreateRelationalDatabaseFromSnapshot Restore a database from a snapshot or point in time · Creates a new database from an existing database snapshot in Amazon Lightsail #
Ask an LLM
“How do I restore a database from one of its snapshots?”
“Can I restore a database to a specific point in time?”
Tell an agent
Create database {relationalDatabaseName} from snapshot {relationalDatabaseSnapshotName}.
Restore {sourceRelationalDatabaseName} as it was at {restoreTime} into new database {relationalDatabaseName}.
POST /ls/api/2016-11-28/CreateRelationalDatabaseSnapshot Take a snapshot of a database · Creates a snapshot of your database in Amazon Lightsail #
Ask an LLM
“How can I back up my managed database right now?”
“Can I use a database snapshot to create a new database later?”
Tell an agent
Snapshot database {relationalDatabaseName} as {relationalDatabaseSnapshotName}.
Create database snapshot {relationalDatabaseSnapshotName} of {relationalDatabaseName}.
POST /ls/api/2016-11-28/DeleteRelationalDatabase Delete a managed database · Deletes a database in Amazon Lightsail #
Ask an LLM
“How do I delete a database but keep a final snapshot?”
“Can I skip the final snapshot when deleting a database?”
Tell an agent destructive · confirm first
Delete database {relationalDatabaseName}, saving final snapshot {finalRelationalDatabaseSnapshotName}.
Delete {relationalDatabaseName} with skip final snapshot set to {skipFinalSnapshot}.
POST /ls/api/2016-11-28/DeleteRelationalDatabaseSnapshot Delete a database snapshot · Deletes a database snapshot in Amazon Lightsail #
Ask an LLM
“How do I remove an old database snapshot?”
“Will deleting a database snapshot affect the running database?”
Tell an agent destructive · confirm first
Delete database snapshot {relationalDatabaseSnapshotName}.
Remove the DB backup {relationalDatabaseSnapshotName}.
POST /ls/api/2016-11-28/GetRelationalDatabase Get one database's details · Returns information about a specific database in Amazon Lightsail #
Ask an LLM
“What's the endpoint and port of my managed database?”
“Is a specific database available or still being created?”
Tell an agent
Get database {relationalDatabaseName}.
Show the endpoint, engine and state of {relationalDatabaseName}.
POST /ls/api/2016-11-28/GetRelationalDatabaseBlueprints List database engines and versions · Returns a list of available database blueprints in Amazon Lightsail #
Ask an LLM
“Which MySQL and PostgreSQL versions can I create?”
“What database blueprints are available?”
Tell an agent
List the database blueprints.
Get more database engine versions from page {pageToken}.
POST /ls/api/2016-11-28/GetRelationalDatabaseBundles List database plans · Returns the list of bundles that are available in Amazon Lightsail #
Ask an LLM
“What database sizes and monthly prices are offered?”
“Are high-availability database plans available?”
Tell an agent
List the database bundles.
List database plans including inactive ones ({includeInactive}).
POST /ls/api/2016-11-28/GetRelationalDatabaseEvents List recent events for a database · Returns a list of events for a specific database in Amazon Lightsail #
Ask an LLM
“What happened to my database in the last few hours — backups, reboots, failovers?”
“Can I look back further than one day of database events?”
Tell an agent
List events for database {relationalDatabaseName}.
Show {relationalDatabaseName} events from the last {durationInMinutes} minutes.
POST /ls/api/2016-11-28/GetRelationalDatabaseLogEvents Read a database log stream · Returns a list of log events for a database in Amazon Lightsail #
Ask an LLM
“How do I read the error log of my managed database?”
“Can I pull slow query log entries between two times?”
Tell an agent
Get {logStreamName} log events for {relationalDatabaseName}.
Show {relationalDatabaseName} {logStreamName} entries from {startTime} to {endTime}.
POST /ls/api/2016-11-28/GetRelationalDatabaseLogStreams List a database's log streams · Returns a list of available log streams for a specific database in Amazon… #
Ask an LLM
“Which log streams (error, general, slow query) does my database have?”
“What log names can I read for a given database?”
Tell an agent
List log streams for database {relationalDatabaseName}.
Show the available log names on {relationalDatabaseName}.
POST /ls/api/2016-11-28/GetRelationalDatabaseMasterUserPassword Retrieve a database's master user password · Returns the current, previous, or pending versions of the master user password… #
Ask an LLM
“I forgot my database admin password — can I retrieve it?”
“Can I see the pending or previous master password after a rotation?”
Tell an agent
Get the master user password for {relationalDatabaseName}.
Show the {passwordVersion} master password of {relationalDatabaseName}.
POST /ls/api/2016-11-28/GetRelationalDatabaseMetricData Get performance metrics for a database · Returns the data points of the specified metric for a database in Amazon… #
Ask an LLM
“How high is my database's CPU utilization?”
“Can I chart database connections or free storage over time?”
Tell an agent
Get {metricName} for database {relationalDatabaseName} from {startTime} to {endTime} every {period}s as {statistics} in {unit}.
Show database {relationalDatabaseName} {metricName} since {startTime}.
POST /ls/api/2016-11-28/GetRelationalDatabaseParameters List a database's engine parameters · Returns all of the runtime parameters offered by the underlying database… #
Ask an LLM
“What engine settings like max_connections is my database using?”
“Which database parameters can be changed and do they need a reboot?”
Tell an agent
List engine parameters for {relationalDatabaseName}.
Get more parameters of {relationalDatabaseName} from page {pageToken}.
POST /ls/api/2016-11-28/GetRelationalDatabaseSnapshot Get one database snapshot's details · Returns information about a specific database snapshot in Amazon Lightsail #
Ask an LLM
“Is my database snapshot complete?”
“Which engine version was a particular database snapshot taken from?”
Tell an agent
Get database snapshot {relationalDatabaseSnapshotName}.
Show the state and size of DB snapshot {relationalDatabaseSnapshotName}.
POST /ls/api/2016-11-28/GetRelationalDatabaseSnapshots List all database snapshots · Returns information about all of your database snapshots in Amazon Lightsail #
Ask an LLM
“What database snapshots do I have?”
“Can I page through every managed database backup?”
Tell an agent
List all my database snapshots.
Get the next page of database snapshots using {pageToken}.
POST /ls/api/2016-11-28/GetRelationalDatabases List all managed databases · Returns information about all of your databases in Amazon Lightsail #
Ask an LLM
“Which managed databases am I running?”
“Is there a way to page through all my Lightsail databases?”
Tell an agent
List all my managed databases.
Get the next page of databases using {pageToken}.
POST /ls/api/2016-11-28/RebootRelationalDatabase Reboot a database · Restarts a specific database in Amazon Lightsail #
Ask an LLM
“How do I restart my managed database to apply parameter changes?”
“Will rebooting a database cause downtime?”
Tell an agent
Reboot database {relationalDatabaseName}.
Restart {relationalDatabaseName} now.
POST /ls/api/2016-11-28/StartRelationalDatabase Start a stopped database · Starts a specific database from a stopped state in Amazon Lightsail #
Ask an LLM
“How do I bring a stopped database back online?”
“Can I start a database I stopped to save money?”
Tell an agent
Start database {relationalDatabaseName}.
Power on the stopped database {relationalDatabaseName}.
POST /ls/api/2016-11-28/StopRelationalDatabase Stop a running database · Stops a specific database that is currently running in Amazon Lightsail #
Ask an LLM
“Can I stop a database temporarily when I'm not using it?”
“Is it possible to snapshot a database as I stop it?”
Tell an agent
Stop database {relationalDatabaseName}.
Stop {relationalDatabaseName} and take snapshot {relationalDatabaseSnapshotName} first.
POST /ls/api/2016-11-28/UpdateRelationalDatabase Change database settings or rotate its password · Allows the update of one or more attributes of a database in Amazon Lightsail #
Ask an LLM
“How do I rotate the master password of my database?”
“Can I change the backup window or turn off public access on a database?”
Tell an agent
Rotate the master password of {relationalDatabaseName} ({rotateMasterUserPassword}).
Set {relationalDatabaseName} public access to {publiclyAccessible} and apply immediately ({applyImmediately}).
POST /ls/api/2016-11-28/UpdateRelationalDatabaseParameters Change database engine parameters · Allows the update of one or more parameters of a database in Amazon Lightsail #
Ask an LLM
“How do I raise max_connections on my managed database?”
“Can I change several engine parameters in one request?”
Tell an agent
Update parameters {parameters} on {relationalDatabaseName}.
Apply engine parameter changes {parameters} to database {relationalDatabaseName}.

Documentation

📖
APIReference
https://docs.aws.amazon.com/lightsail/2016-11-28/api-reference/Welcome.html
📖
Documentation
https://docs.aws.amazon.com/lightsail/latest/userguide/what-is-amazon-lightsail.html
📖
GettingStarted
https://aws.amazon.com/lightsail/getting-started/

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/amazon-lightsail/refs/heads/main/openapi/amazon-lightsail-relational-databases-api-openapi.yml

Schemas & Data

📊
JSONSchema
https://raw.githubusercontent.com/api-evangelist/amazon-lightsail/refs/heads/main/json-schema/amazon-lightsail-instance-schema.json

Other Resources

🔗
Smithy
https://raw.githubusercontent.com/api-evangelist/amazon-lightsail/refs/heads/main/smithy/amazon-lightsail-2016-11-28.json
🔗
Pricing
https://aws.amazon.com/lightsail/pricing/
🔗
FAQ
https://aws.amazon.com/lightsail/faq/
🔗
JSONLD
https://raw.githubusercontent.com/api-evangelist/amazon-lightsail/refs/heads/main/json-ld/amazon-lightsail-context.jsonld

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/amazon-lightsail:amazon-lightsail-relational-databases-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

amazon-lightsail-relational-databases-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Amazon Lightsail Relational Databases API
  description: Amazon Lightsail is the easiest way to get started with Amazon Web Services (AWS) for developers who need to build websites or web applications.
  version: '2016-11-28'
  contact:
    name: AWS Support
    url: https://aws.amazon.com/premiumsupport/
  license:
    name: Apache 2.0
    url: https://www.apache.org/licenses/LICENSE-2.0.html
  x-logo:
    url: https://a0.awsstatic.com/libra-css/images/logos/aws_logo_smile_1200x630.png
  x-generated-from: AWS Smithy 2.0 service model (https://github.com/aws/api-models-aws) — mechanical transform, no hand-authored operations
servers:
- url: https://lightsail.us-east-1.amazonaws.com
  description: Amazon Lightsail regional endpoint (us-east-1). Lightsail is regional — one endpoint per AWS Region, lightsail.{region}.amazonaws.com (IPv4) or lightsail.{region}.api.aws (dual-stack). See https://docs.aws.amazon.com/general/latest/gr/lightsail.html
security:
- sigv4: []
tags:


# --- truncated at 32 KB (124 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/amazon-lightsail/refs/heads/main/openapi/amazon-lightsail-relational-databases-api-openapi.yml