Prompt file imported from wdenk/agenticengineering-tac5 (.claude/commands/e2e/test_field_preview_statistics.md). Copyright stays with the author.

E2E Test: Field Preview Statistics

Test that compact summary statistics appear below each column type badge in the schema panel after uploading sample data.

User Story

As a data analyst using the Natural Language SQL Interface I want to see a quick summary statistic for each field in the schema preview So that I can understand the shape of my data at a glance before writing queries

Test Steps

1. Navigate to the Application URL

2. Take a screenshot of the initial state (empty schema panel)

3. Verify core UI elements are present:

   • Query input textbox
   • "Upload Data" button
   • "Available Tables" section showing no tables loaded

4. Click the "Upload Data" button to open the upload modal

5. Click the "Users Data" sample button to load the users dataset

6. Wait for upload success (modal should close and success message should appear)

7. Verify the "users" table appears in the "Available Tables" section

8. Take a screenshot of the schema panel with the users table loaded

9. Wait 2 seconds for field stats to load asynchronously

10. Take a close screenshot of the column stats area in the users table

11. Verify that at least one column tag in the users table contains a stat element:

    • Look for .mini-bar-chart elements (for numeric or category columns)
    • Or .stat-inline elements (for id or date columns)
    • At minimum, the schema panel should render columns successfully

12. Verify that an INTEGER non-id column (e.g., age) shows a bar chart with .mini-bar-chart class (numeric distribution)

13. Verify that a column named name or email shows NO stat element (personal data is skipped for privacy)

14. Click the "Upload Data" button again

15. Click the "Products Data" (or similar) sample button to load a second dataset with categorical data

16. Wait for upload success

17. Take a screenshot of the full schema panel with multiple tables

18. Verify that a TEXT category column in any loaded table shows top-values bars (.mini-bar-chart)

19. Take a final screenshot of the complete schema panel showing field stats

Success Criteria

• After uploading Users Data, the "users" table appears in the schema panel
• At least one column in the users table shows a stat element (.mini-bar-chart or .stat-inline)
• The age column (INTEGER non-id) shows a distribution bar chart
• Columns named name or email show no stat element (personal data privacy)
• Stats load without blocking the schema panel render
• At least 3 screenshots are captured