planets

Pack: exoplanet-archive · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/planets for the schema, then POST the same URL with its arguments for the data.

Quick planet search against the ps (planetary systems) table.

Parameters

NameTypeRequiredDescription
querystringnoOptional WHERE clause (without “WHERE”).
limitnumberno1-10000 (default 25).

Example call

Arguments

{
  "query": "pl_massj > 5.0",
  "limit": 10
}

curl

curl -X POST https://gateway.pipeworx.io/exoplanet-archive/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"planets","arguments":{"query":"pl_massj > 5.0","limit":10}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('planets', {
  "query": "pl_massj > 5.0",
  "limit": 10
});

More examples

{
  "query": "sy_dist < 50"
}

Response shape

FieldTypeDescription
itemsarray
countnumber
Full JSON Schema
{
  "type": "object",
  "properties": {
    "items": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "pl_name": {
            "type": "string"
          },
          "pl_letter": {
            "type": [
              "string",
              "null"
            ]
          },
          "hostname": {
            "type": "string"
          },
          "hd_name": {
            "type": [
              "null",
              "string"
            ]
          },
          "hip_name": {
            "type": [
              "null",
              "string"
            ]
          },
          "tic_id": {
            "type": [
              "null",
              "string"
            ]
          },
          "gaia_dr2_id": {
            "type": [
              "null",
              "string"
            ]
          },
          "gaia_dr3_id": {
            "type": [
              "null",
              "string"
            ]
          },
          "default_flag": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_refname": {
            "type": [
              "string",
              "null"
            ]
          },
          "sy_refname": {
            "type": [
              "string",
              "null"
            ]
          },
          "disc_pubdate": {
            "type": [
              "string",
              "null"
            ]
          },
          "disc_year": {
            "type": [
              "number",
              "null"
            ]
          },
          "discoverymethod": {
            "type": [
              "string",
              "null"
            ]
          },
          "disc_locale": {
            "type": [
              "string",
              "null"
            ]
          },
          "disc_facility": {
            "type": [
              "string",
              "null"
            ]
          },
          "disc_instrument": {
            "type": [
              "string",
              "null"
            ]
          },
          "disc_telescope": {
            "type": [
              "string",
              "null"
            ]
          },
          "disc_refname": {
            "type": [
              "string",
              "null"
            ]
          },
          "ra": {
            "type": [
              "number",
              "null"
            ]
          },
          "rastr": {
            "type": [
              "string",
              "null"
            ]
          },
          "dec": {
            "type": [
              "number",
              "null"
            ]
          },
          "decstr": {
            "type": [
              "string",
              "null"
            ]
          },
          "glon": {
            "type": [
              "number",
              "null"
            ]
          },
          "glat": {
            "type": [
              "number",
              "null"
            ]
          },
          "elon": {
            "type": [
              "number",
              "null"
            ]
          },
          "elat": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbper": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbpererr1": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbpererr2": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbperlim": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbperstr": {
            "type": [
              "string",
              "null"
            ]
          },
          "pl_orblpererr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_orblper": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_orblpererr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_orblperlim": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_orblperstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "pl_orbsmax": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbsmaxerr1": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbsmaxerr2": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbsmaxlim": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbsmaxstr": {
            "type": [
              "string",
              "null"
            ]
          },
          "pl_orbincl": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbinclerr1": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbinclerr2": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbincllim": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbinclstr": {
            "type": [
              "string",
              "null"
            ]
          },
          "pl_orbtper": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbtpererr1": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbtpererr2": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbtperlim": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbtperstr": {
            "type": [
              "string",
              "null"
            ]
          },
          "pl_orbeccen": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbeccenerr1": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbeccenerr2": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbeccenlim": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_orbeccenstr": {
            "type": [
              "string",
              "null"
            ]
          },
          "pl_eqt": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_eqterr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_eqterr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_eqtlim": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_eqtstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "pl_occdep": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_occdeperr1": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_occdeperr2": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_occdeplim": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_occdepstr": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_insol": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_insolerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_insolerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_insollim": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_insolstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "pl_dens": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_denserr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_denserr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_denslim": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_densstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "pl_trandep": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_trandeperr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_trandeperr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_trandeplim": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_trandepstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "pl_tranmid": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_tranmiderr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_tranmiderr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_tranmidlim": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_tranmidstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "pl_trandur": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_trandurerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_trandurerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_trandurlim": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_trandurstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "sy_kmagstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "sy_umag": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_umagerr1": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_umagerr2": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_umagstr": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_rmag": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_rmagerr1": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_rmagerr2": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_rmagstr": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_imag": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_imagerr1": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_imagerr2": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_imagstr": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_zmag": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_zmagerr1": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_zmagerr2": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_zmagstr": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_w1mag": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_w1magerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_w1magerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_w1magstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "sy_w2mag": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_w2magerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_w2magerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_w2magstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "sy_w3mag": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_w3magerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_w3magerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_w3magstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "sy_w4mag": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_w4magerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_w4magerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_w4magstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "sy_gmag": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_gmagerr1": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_gmagerr2": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_gmagstr": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_gaiamag": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_gaiamagerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_gaiamagerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_gaiamagstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "sy_tmag": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_tmagerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_tmagerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_tmagstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "pl_controv_flag": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_tsystemref": {
            "type": [
              "string",
              "null"
            ]
          },
          "st_metratio": {
            "type": [
              "null",
              "string"
            ]
          },
          "st_spectype": {
            "type": [
              "null",
              "string"
            ]
          },
          "sy_kepmag": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_kepmagerr1": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_kepmagerr2": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_kepmagstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "st_rotp": {
            "description": "(type varies; observed both null and non-null)"
          },
          "st_rotperr1": {
            "description": "(type varies; observed both null and non-null)"
          },
          "st_rotperr2": {
            "description": "(type varies; observed both null and non-null)"
          },
          "st_rotplim": {
            "description": "(type varies; observed both null and non-null)"
          },
          "st_rotpstr": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_projobliq": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_projobliqerr1": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_projobliqerr2": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_projobliqlim": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_projobliqstr": {
            "description": "(type varies; observed both null and non-null)"
          },
          "x": {
            "type": [
              "number",
              "null"
            ]
          },
          "y": {
            "type": [
              "number",
              "null"
            ]
          },
          "z": {
            "type": [
              "number",
              "null"
            ]
          },
          "htm20": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_rvamp": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_rvamperr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_rvamperr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_rvamplim": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_rvampstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "pl_radj": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_radjerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_radjerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_radjlim": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_radjstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "pl_rade": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_radeerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_radeerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_radelim": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_radestr": {
            "type": [
              "null",
              "string"
            ]
          },
          "pl_ratror": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_ratrorerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_ratrorerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_ratrorlim": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_ratrorstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "pl_ratdor": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_trueobliq": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_trueobliqerr1": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_trueobliqerr2": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_trueobliqlim": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_trueobliqstr": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_icmag": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_icmagerr1": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_icmagerr2": {
            "description": "(type varies; observed both null and non-null)"
          },
          "sy_icmagstr": {
            "description": "(type varies; observed both null and non-null)"
          },
          "rowupdate": {
            "type": [
              "string",
              "null"
            ]
          },
          "pl_pubdate": {
            "type": [
              "string",
              "null"
            ]
          },
          "st_refname": {
            "type": [
              "string",
              "null"
            ]
          },
          "releasedate": {
            "type": [
              "string",
              "null"
            ]
          },
          "dkin_flag": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_ratdorerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_ratdorerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_ratdorlim": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_ratdorstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "pl_imppar": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_impparerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_impparerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_impparlim": {
            "type": [
              "null",
              "number"
            ]
          },
          "pl_impparstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "pl_cmassj": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_cmassjerr1": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_cmassjerr2": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_cmassjlim": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_cmassjstr": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_cmasse": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_cmasseerr1": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_cmasseerr2": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_cmasselim": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_cmassestr": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_massj": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_massjerr1": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_massjerr2": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_massjlim": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_massjstr": {
            "type": [
              "string",
              "null"
            ]
          },
          "pl_masse": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_masseerr1": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_masseerr2": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_masselim": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_massestr": {
            "type": [
              "string",
              "null"
            ]
          },
          "pl_bmassj": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_bmassjerr1": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_bmassjerr2": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_bmassjlim": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_bmassjstr": {
            "type": [
              "string",
              "null"
            ]
          },
          "pl_bmasse": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_bmasseerr1": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_bmasseerr2": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_bmasselim": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_bmassestr": {
            "type": [
              "string",
              "null"
            ]
          },
          "pl_bmassprov": {
            "type": [
              "string",
              "null"
            ]
          },
          "pl_msinij": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_msinijerr1": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_msinijerr2": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_msinijlim": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_msinijstr": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_msinie": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_msinieerr1": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_msinieerr2": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_msinielim": {
            "description": "(type varies; observed both null and non-null)"
          },
          "pl_msiniestr": {
            "description": "(type varies; observed both null and non-null)"
          },
          "st_teff": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_tefferr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_tefferr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_tefflim": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_teffstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "st_met": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_meterr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_meterr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_metlim": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_metstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "st_radv": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_radverr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_radverr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_radvlim": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_radvstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "st_vsin": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_vsinerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_vsinerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_vsinlim": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_vsinstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "st_lum": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_lumerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_lumerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_lumlim": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_lumstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "st_logg": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_loggerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_loggerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_logglim": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_loggstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "st_age": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_ageerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_ageerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_agelim": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_agestr": {
            "type": [
              "null",
              "string"
            ]
          },
          "st_mass": {
            "type": [
              "number",
              "null"
            ]
          },
          "st_masserr1": {
            "type": [
              "number",
              "null"
            ]
          },
          "st_masserr2": {
            "type": [
              "number",
              "null"
            ]
          },
          "st_masslim": {
            "type": [
              "number",
              "null"
            ]
          },
          "st_massstr": {
            "type": [
              "string",
              "null"
            ]
          },
          "st_dens": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_denserr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_denserr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_denslim": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_densstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "st_rad": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_raderr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_raderr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_radlim": {
            "type": [
              "null",
              "number"
            ]
          },
          "st_radstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "ttv_flag": {
            "type": [
              "number",
              "null"
            ]
          },
          "ptv_flag": {
            "type": [
              "number",
              "null"
            ]
          },
          "tran_flag": {
            "type": [
              "number",
              "null"
            ]
          },
          "rv_flag": {
            "type": [
              "number",
              "null"
            ]
          },
          "ast_flag": {
            "type": [
              "number",
              "null"
            ]
          },
          "obm_flag": {
            "type": [
              "number",
              "null"
            ]
          },
          "micro_flag": {
            "type": [
              "number",
              "null"
            ]
          },
          "etv_flag": {
            "type": [
              "number",
              "null"
            ]
          },
          "ima_flag": {
            "type": [
              "number",
              "null"
            ]
          },
          "pul_flag": {
            "type": [
              "number",
              "null"
            ]
          },
          "soltype": {
            "type": [
              "string",
              "null"
            ]
          },
          "sy_snum": {
            "type": [
              "number",
              "null"
            ]
          },
          "sy_pnum": {
            "type": [
              "number",
              "null"
            ]
          },
          "sy_mnum": {
            "type": [
              "number",
              "null"
            ]
          },
          "cb_flag": {
            "type": [
              "number",
              "null"
            ]
          },
          "st_nphot": {
            "type": [
              "number",
              "null"
            ]
          },
          "st_nrvc": {
            "type": [
              "number",
              "null"
            ]
          },
          "st_nspec": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_nespec": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_ntranspec": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_ndispec": {
            "type": [
              "number",
              "null"
            ]
          },
          "pl_nnotes": {
            "type": [
              "number",
              "null"
            ]
          },
          "sy_pm": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_pmerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_pmerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_pmstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "sy_pmra": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_pmraerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_pmraerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_pmrastr": {
            "type": [
              "null",
              "string"
            ]
          },
          "sy_pmdec": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_pmdecerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_pmdecerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_pmdecstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "sy_plx": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_plxerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_plxerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_plxstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "sy_dist": {
            "type": [
              "number",
              "null"
            ]
          },
          "sy_disterr1": {
            "type": [
              "number",
              "null"
            ]
          },
          "sy_disterr2": {
            "type": [
              "number",
              "null"
            ]
          },
          "sy_diststr": {
            "type": [
              "string",
              "null"
            ]
          },
          "sy_bmag": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_bmagerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_bmagerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_bmagstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "sy_vmag": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_vmagerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_vmagerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_vmagstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "sy_jmag": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_jmagerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_jmagerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_jmagstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "sy_hmag": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_hmagerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_hmagerr2": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_hmagstr": {
            "type": [
              "null",
              "string"
            ]
          },
          "sy_kmag": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_kmagerr1": {
            "type": [
              "null",
              "number"
            ]
          },
          "sy_kmagerr2": {
            "type": [
              "null",
              "number"
            ]
          }
        }
      }
    },
    "count": {
      "type": "number"
    }
  },
  "description": "Query result from planetary systems (ps) table"
}

Connect

Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://pipeworx.io/mcp"
    }
  }
}
Connect to just the exoplanet-archive pack
{
  "mcpServers": {
    "exoplanet-archive": {
      "url": "https://gateway.pipeworx.io/exoplanet-archive/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

Regenerated from source · build October 5, 2026