Function getTableRowCount

src/tools/search-objects.ts:95–118

* Get row count estimate for a table. * Prefers the connector's native statistics-based method (e.g. pg_class.reltuples) * when available, falling back to COUNT(*) for connectors that don't implement it.

(
  connector: Connector,
  tableName: string,
  schemaName?: string
)

 * when available, falling back to COUNT(*) for connectors that don't implement it.
 */
async function getTableRowCount(
  connector: Connector,
  tableName: string,
  schemaName?: string
): Promise<number | null> {
  try {
    if (connector.getTableRowCount) {
      return await connector.getTableRowCount(tableName, schemaName);
    }

    // Fallback: COUNT(*) for connectors without a statistics-based implementation
    const qualifiedTable = quoteQualifiedIdentifier(tableName, schemaName, connector.id);
    const countQuery = `SELECT COUNT(*) as count FROM ${qualifiedTable}`;
    const result = await connector.executeSQL(countQuery, { maxRows: 1 });

    if (result.rows && result.rows.length > 0) {
      return Number(result.rows[0].count || result.rows[0].COUNT || 0);
    }
  } catch (error) {
    // If we can't get row count, return null (not critical)
    return null;
  }
  return null;
}

/**
 * Get table comment from the connector if supported.