Skip to content

UUIDv7 serialized to Array of numbers. #3795

Description

@xmlking

Prerequisites

  • I've searched the current open issues
  • I've updated to the latest version of Toolbox

Toolbox version

1.8.0

Environment

  1. OS type and version: (output of uname -a)
  2. How are you running Toolbox:
  • As a downloaded binary (e.g. from curl -O https://storage.googleapis.com/mcp-toolbox-for-databases/v$VERSION/linux/amd64/toolbox)
  • As a container (e.g. from us-central1-docker.pkg.dev/database-toolbox/toolbox/toolbox:$VERSION)
  • Compiled from source (include the command used to build)

Client

  1. Client:
  2. Version:
  3. Example: If possible, please include your code of configuration:
# Code goes here! 

Expected Behavior

I am using Postgres 18 , for ID, was expecting string but got array of numbers.

CREATE TABLE "organization" (
	"id" uuid PRIMARY KEY DEFAULT uuidv7(),
	"name" text NOT NULL,
	"slug" text NOT NULL UNIQUE,
	"logo" text,
	"created_at" timestamp NOT NULL,
	"metadata" text
);

tools.yaml

tools:
  list_organizations:
    kind: postgres-sql
    source: webapp-db
    description: >
      List all organizations, with the organization's name.
    parameters: []
    statement: >
      SELECT o.id,
             o.name,
             o.created_at
      FROM organization o
      ORDER BY o.created_at DESC
      LIMIT 10;

Output

{
  "id": [
    1,
    158,
    103,
    138,
    45,
    22,
    120,
    229,
    146,
    32,
    191,
    118,
    245,
    114,
    247,
    50
  ],
  "name": "Hello",
  "created_at": "2025-10-19T11:49:04.419Z"
}

Current Behavior

for ID, was expecting string but got array of numbers.

Steps to reproduce?

CREATE TABLE "organization" (
	"id" uuid PRIMARY KEY DEFAULT uuidv7(),
	"name" text NOT NULL,
	"slug" text NOT NULL UNIQUE,
	"logo" text,
	"created_at" timestamp NOT NULL,
	"metadata" text
);

tools.yaml

tools:
  list_organizations:
    kind: postgres-sql
    source: webapp-db
    description: >
      List all organizations, with the organization's name.
    parameters: []
    statement: >
      SELECT o.id,
             o.name,
             o.created_at
      FROM organization o
      ORDER BY o.created_at DESC
      LIMIT 10;

Additional Details

No response

Metadata

Metadata

Assignees

Labels

priority: p1Important issue which blocks shipping the next release. Will be fixed prior to next release.type: bugError or flaw in code with unintended results or allowing sub-optimal usage patterns.

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions