Community
LLM Benchmark
Detailed Eval Results
How well do leading LLMs write SpacetimeDB code? We prompt each model, run the generated code against live modules, and score with automated checks.
Gemini 3.5 Flash
Typescript · With Guidelines0.0%Task Pass Rate
0/89Checks Passed
47Total Evals
Pass Rate Over Time
Click a data point to view results from that date.
auth
0% · 8 evals| Status | Task ID | Checks | Run Time | |
|---|---|---|---|---|
| ✗ | t_026_auth_identity_check | 0/1 | 3.5s | ▼ |
| ✗ | t_027_private_vs_public_table | 0/1 | 3.4s | ▼ |
| ✗ | t_041_registered_user_gate | 0/1 | 3.9s | ▼ |
| ✗ | t_042_admin_bootstrap | 0/1 | 4.6s | ▼ |
| ✗ | t_043_role_based_access | 0/1 | 4.2s | ▼ |
| ✗ | t_044_ban_list | 0/1 | 4.4s | ▼ |
| ✗ | t_045_rate_limit | 0/1 | 3.4s | ▼ |
| ✗ | t_046_shared_document | 0/1 | 4.5s | ▼ |
basics
0% · 15 evals| Status | Task ID | Checks | Run Time | |
|---|---|---|---|---|
| ✗ | t_000_empty_reducers | 0/1 | 3.8s | ▼ |
| ✗ | t_001_basic_tables | 0/1 | 3.4s | ▼ |
| ✗ | t_002_scheduled_table | 0/1 | 3.4s | ▼ |
| ✗ | t_003_struct_in_table | 0/1 | 3.4s | ▼ |
| ✗ | t_004_insert | 0/2 | 3.9s | ▼ |
| ✗ | t_005_update | 0/3 | 4.3s | ▼ |
| ✗ | t_006_delete | 0/3 | 4.0s | ▼ |
| ✗ | t_007_crud | 0/4 | 3.9s | ▼ |
| ✗ | t_008_index_lookup | 0/3 | 4.3s | ▼ |
| ✗ | t_009_init | 0/4 | 3.9s | ▼ |
| ✗ | t_010_connect | 0/1 | 3.5s | ▼ |
| ✗ | t_011_helper_function | 0/3 | 3.7s | ▼ |
| ✗ | t_038_schedule_at_time | 0/1 | 2.9s | ▼ |
| ✗ | t_039_cancel_schedule | 0/1 | 3.5s | ▼ |
| ✗ | t_040_lifecycle_player | 0/1 | 4.2s | ▼ |
data modeling
0% · 6 evals| Status | Task ID | Checks | Run Time | |
|---|---|---|---|---|
| ✗ | t_024_event_table | 0/1 | 3.0s | ▼ |
| ✗ | t_025_optional_fields | 0/1 | 3.9s | ▼ |
| ✗ | t_028_cascade_delete | 0/1 | 3.9s | ▼ |
| ✗ | t_029_filter_and_aggregate | 0/1 | 4.4s | ▼ |
| ✗ | t_030_two_table_join | 0/1 | 4.0s | ▼ |
| ✗ | t_031_unique_constraint | 0/1 | 3.5s | ▼ |
queries
0% · 8 evals| Status | Task ID | Checks | Run Time | |
|---|---|---|---|---|
| ✗ | t_022_view_basic | 0/1 | 3.2s | ▼ |
| ✗ | t_023_view_per_user | 0/1 | 5.3s | ▼ |
| ✗ | t_035_select_distinct | 0/1 | 4.8s | ▼ |
| ✗ | t_032_range_query | 0/1 | 4.7s | ▼ |
| ✗ | t_033_sort_and_limit | 0/1 | 6.2s | ▼ |
| ✗ | t_034_find_first | 0/1 | 5.7s | ▼ |
| ✗ | t_036_count_without_collect | 0/1 | 5.2s | ▼ |
| ✗ | t_037_multi_column_filter | 0/1 | 4.7s | ▼ |
schema
0% · 10 evals| Status | Task ID | Checks | Run Time | |
|---|---|---|---|---|
| ✗ | t_012_spacetime_product_type | 0/3 | 3.4s | ▼ |
| ✗ | t_013_spacetime_sum_type | 0/3 | 3.0s | ▼ |
| ✗ | t_014_elementary_columns | 0/3 | 2.8s | ▼ |
| ✗ | t_015_product_type_columns | 0/3 | 3.2s | ▼ |
| ✗ | t_016_sum_type_columns | 0/3 | 3.2s | ▼ |
| ✗ | t_017_scheduled_columns | 0/2 | 2.8s | ▼ |
| ✗ | t_018_constraints | 0/3 | 3.1s | ▼ |
| ✗ | t_019_many_to_many | 0/5 | 4.5s | ▼ |
| ✗ | t_020_ecs | 0/7 | 5.2s | ▼ |
| ✗ | t_021_multi_column_index | 0/5 | 4.3s | ▼ |