> ## Documentation Index > Fetch the complete documentation index at: https://www.latitude.sh/docs/llms.txt > Use this file to discover all available pages before exploring further. # Show a managed database ## OpenAPI ````yaml https://spec.speakeasy.com/latitude/latitude/latitude-sh-api-with-code-samples get /managed_databases/{id} openapi: 3.0.1 info: title: Latitude.sh API version: '2023-06-01' description: >- The Latitude.sh API is a RESTful API to manage your Latitude.sh account. It allows you to perform the same actions as the Latitude.sh dashboard. servers: - url: https://api.latitude.sh variables: latitude_api_key: default: - url: http://api.latitude.sh variables: latitude_api_key: default: security: [] tags: - name: API keys - name: Baselines (Preview) description: >- Preview. Available to teams with the `baselines_api` feature flag. The shape of these endpoints may change before general availability. - name: Billing - name: Elastic Ips - name: Events - name: Firewalls - name: IP Addresses - name: Managed Databases description: Managed database instances (PostgreSQL, ClickHouse) - name: Kubernetes Clusters - name: LKS - name: Marketplace apps - name: Operating Systems - name: Plans - name: Public Networks - name: Private Networks - name: Projects - name: Regions - name: Roles - name: SSH Keys - name: Servers - name: Block Storage - name: Filesystem Storage - name: Object Storage - name: Tags - name: Teams - name: Team members - name: Traffic - name: User data - name: User profile - name: VPN Sessions - name: Virtual machines - name: Virtual machine backups - name: Virtual machine restores paths: /managed_databases/{id}: get: tags: - Managed Databases summary: Show a managed database operationId: show-managed-database parameters: - name: id in: path required: true schema: type: string description: Managed database ID responses: '200': description: OK content: application/vnd.api+json: schema: $ref: '#/components/schemas/managed_database' security: - Bearer: [] x-codeSamples: - lang: python label: Python (SDK) source: |- from latitudesh_python_sdk import Latitudesh import os with Latitudesh( bearer=os.getenv("LATITUDESH_BEARER", ""), ) as latitudesh: res = latitudesh.managed_databases.show_managed_database(id="") # Handle response print(res) - lang: go label: Go (SDK) source: "package main\n\nimport(\n\t\"context\"\n\t\"os\"\n\tlatitudeshgosdk \"github.com/latitudesh/latitudesh-go-sdk\"\n\t\"log\"\n)\n\nfunc main() {\n ctx := context.Background()\n\n s := latitudeshgosdk.New(\n latitudeshgosdk.WithSecurity(os.Getenv(\"LATITUDESH_BEARER\")),\n )\n\n res, err := s.ManagedDatabases.ShowManagedDatabase(ctx, \"\")\n if err != nil {\n log.Fatal(err)\n }\n if res.ManagedDatabase != nil {\n // handle response\n }\n}" - lang: typescript label: Typescript (SDK) source: |- import { Latitudesh } from "latitudesh-typescript-sdk"; const latitudesh = new Latitudesh({ bearer: process.env["LATITUDESH_BEARER"] ?? "", }); async function run() { const result = await latitudesh.managedDatabases.showManagedDatabase({ id: "", }); console.log(result); } run(); components: schemas: managed_database: type: object properties: data: $ref: '#/components/schemas/managed_database_attributes' managed_database_attributes: type: object properties: id: type: string example: db_a1b2c3d4 type: type: string enum: - managed_databases attributes: type: object properties: name: type: string engine: type: string status: type: string namespace: type: string nullable: true created_at: type: string nullable: true specs: type: object nullable: true properties: cpu: type: integer nullable: true memory: type: integer nullable: true storage: type: integer nullable: true shards: type: integer nullable: true replicas: type: integer nullable: true iops: type: string nullable: true region: type: object properties: city: type: string nullable: true country: type: string nullable: true site: type: object nullable: true properties: id: type: string name: type: string slug: type: string facility: type: string plan: type: object properties: id: type: string name: type: string nullable: true slug: type: string nullable: true billing: type: string team: $ref: '#/components/schemas/team_include' nullable: true project: $ref: '#/components/schemas/project_include' nullable: true trusted_sources: type: array items: type: string description: Array of CIDR addresses allowed to connect play_url: type: string nullable: true credentials: type: object nullable: true properties: host: type: string http_port: type: integer nullable: true tcp_port: type: integer nullable: true port: type: integer nullable: true description: Postgres NodePort database: type: string nullable: true url: type: string nullable: true description: Postgres connection string username: type: string password: type: string nullable: true parameters: type: object additionalProperties: type: string description: Custom PostgreSQL parameters pooler: type: object additionalProperties: true description: PgBouncer pooler configuration backup: type: object additionalProperties: true description: Scheduled backup configuration recovery: type: object properties: enabled: type: boolean nullable: true supabase: type: object properties: enabled: type: boolean team_include: type: object properties: id: type: string name: type: string slug: type: string description: type: string nullable: true address: type: string nullable: true currency: type: object properties: id: type: string code: type: string name: type: string currency_id: type: integer nullable: true status: type: string nullable: true feature_flags: type: array items: type: string limits: type: object properties: bare_metal: type: integer nullable: true bare_metal_gpu: type: integer nullable: true virtual_machine: type: integer nullable: true virtual_machine_gpu: type: integer nullable: true elastic_ip: type: integer nullable: true bgp_session_per_ip: type: integer nullable: true public_network: type: integer nullable: true virtual_network: type: integer nullable: true database: type: integer nullable: true filesystem: type: integer nullable: true block_storage: type: integer nullable: true project_include: type: object properties: id: type: string name: type: string slug: type: string description: type: string nullable: true billing_type: type: string nullable: true provisioning_type: type: string nullable: true billing_method: type: string nullable: true bandwidth_alert: type: boolean environment: type: string nullable: true billing: type: object properties: subscription_id: type: string nullable: true type: type: string method: type: string stats: type: object properties: databases: type: integer ip_addresses: type: integer prefixes: type: integer servers: type: integer storages: type: integer virtual_machines: type: integer vlans: type: integer securitySchemes: Bearer: type: apiKey name: Authorization in: header ```` This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.