Datasette just took a giant leap forward. The latest alpha release packs powerful new features that transform how users explore and interact with data. Want to write directly to your databases through a sleek web interface? Now you can. Hungry for smarter, AI-powered navigation inside your data? That’s here too. This is not your typical alpha—it’s a playground for data pros and developers hungry for speed and flexibility.

Write Queries and Save Them Like a Pro

Datasette 1.0a31 lets users with permission execute write queries. That means you can now insert, update, or delete data right from the interface. No more jumping between tools or scripts. It’s all in one place. But that’s not all—stored queries, formerly known as “canned queries,” got a serious upgrade. You can save your queries privately or share them with team members. Collaboration just got a turbo boost.

Imagine running templated insert or update commands without messing with SQL every time. The new execute query interface guides you through it. It’s perfect for users who want control without the hassle. This feature is a game-changer for publishing and managing live data on the web.

Jump Into Data Faster With the Customizable “Jump To” Menu

Just hit the forward slash key (/) and watch Datasette’s new “Jump to…” menu spring to life. This feature debuted in version 1.0a30 and is already shaking up data navigation. Instead of clicking through endless lists, users can instantly jump to tables, views, queries, or even plugin-provided items. It’s lightning-fast and keyboard-friendly.

What sets this menu apart is its extensibility. The new jump_items_sql() plugin hook lets developers add custom items through SQL. That means you can tailor the menu to your database’s unique shape or your project’s workflows. Need shortcuts to specific reports, dashboards, or tools? Just plug them in. The menu also supports defining blank-state sections before you start typing, thanks to a JavaScript hook developers adore.

• Quick access to databases, views, and stored queries
• Plugin-driven extensions via SQL hooks
• Keyboard shortcuts and ARIA accessibility built in
• Debug menu links integrated for easy troubleshooting

This is a leap for data explorers who want to slice through complexity and get to the info they need—fast.

AI Agents Join the Party in the Jump Menu

Datasette’s ecosystem just got smarter. The companion plugin datasette-agent leverages the new menu to bring AI chat right into the interface. Hit /, select “Start a new agent chat,” and an AI assistant is ready to help. This isn’t just a chatbot. It’s an agent built to understand your datasets and answer questions or execute commands.

This feature rides on the new makeJumpSections() JavaScript hook, which allows injecting custom sections into the Jump menu. The agent integration is a live demonstration of Datasette’s commitment to building extensible tools that combine data and AI seamlessly.

Developer Tools and Ecosystem Growth

Alongside these headline features, the release includes updates that make life easier for plugin developers and testers. There’s a new helper to populate fixture databases for testing, keyboard and accessibility improvements, and a dropped dependency that cleans up the codebase.

Simon Willison, the project lead, is shipping not just core updates but companion plugins that showcase how to harness the new APIs. It’s a masterclass in open-source momentum that invites developers to build and innovate.

What’s Next for Datasette?

The alpha releases show a clear vision: empower users to interact with data directly and dynamically. The integration of AI agents hints at a future where data exploration is not just faster but smarter. This is the start of a new era for open-source data tools.

For data pros, researchers, and developers, this means fewer barriers and more power at your fingertips. The future will bring even deeper AI integration, more customizable interfaces, and tools that adapt to your workflows. Datasette is shaping up to be the ultimate data exploration platform—accessible, extensible, and ready for the AI age.

Get ready to explore data like never before. The next alpha could be your secret weapon.