list_columns
List available data fields in NASA Exoplanet Archive tables, including types, descriptions, and units, to choose columns for searches or ADQL queries. Filter by category to narrow options.
Instructions
List available columns for a table in the NASA Exoplanet Archive, with data types, descriptions, and units. Use this to discover what data fields exist before selecting specific columns in search_planets or writing ADQL queries with run_query.
The main planet table (pscomppars) has 300+ columns. Use the category filter to narrow results to a manageable set. You do not need this for basic queries — search_planets returns a useful default column set. Use this when the user asks about specific properties that may not be in the defaults, or before formulating a run_query call.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | No | Table name (default: 'pscomppars'). Use list_tables to see all available tables. | pscomppars |
| category | No | Filter columns by category. One of: orbital (period, eccentricity, inclination), physical (radius, mass, density, temperature), stellar (host star properties), discovery (method, year, facility), system (distance, coordinates, counts), photometry (magnitudes in various bands). If omitted, queries the archive for all columns in the table. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |