> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# DBeaver: Database Management Tool with Kevin Bell
- URL: https://nolongerset.com/aug-dbeaver/
- Published: 2025-02-06T02:53:05.000Z
- Updated: 2026-05-08T12:43:51.000Z
- Description: How to Visualize and Document Complex Database Relationships Beyond Access (an Access User Group talk with Kevin Bell)
- Author: Mike Wolfe
- Tags: AUG Video Recap, #Import 2026-05-20 02:59

A free, open-source database tool that puts advanced SQL Server Management Studio-like features within reach of every Access developer.

Kevin Bell shared his experience with DBeaver, a powerful cross-platform database management tool, at a recent Access Pacific user group presentation. The tool offers a comprehensive set of features for working with multiple database platforms, including Microsoft Access and SQL Server, with particular emphasis on its superior entity relationship diagramming (ERD) capabilities.

Whether you're trying to understand an inherited database's structure or looking for a more flexible alternative to Access's relationship window, this presentation demonstrates why DBeaver deserves a spot in your development toolkit.

## Key Features

### Cross-Platform Support

- Works on Windows, Mac, and Linux
- Supports multiple database types (Access, SQL Server, MySQL, etc.)
- Free community edition with robust feature set
- Paid "Pro" version available with additional features

### Database Navigation

- Tree-view interface for exploring database objects
- Easy access to tables, views, and schemas
- Built-in data viewer with filtering capabilities
- Value panel shows related data for foreign keys

### ERD Capabilities

- Create multiple diagrams (unlike Access's single relationship window)
- Automatic relationship detection and visualization
- Custom layout options with zoom and pan controls
- Ability to save different views of database relationships

### SQL Features

- SQL editor with syntax highlighting
- Query builder functionality
- Results grid with data editing capabilities
- Schema comparison tools

## Implementation Details

### ERD Creation

- Generate full database diagrams automatically
- Create custom diagrams by selecting specific tables
- Add virtual relationships between databases
- Include annotations and notes in diagrams

### Data Viewing

- Grid and record views available
- Filter and sort capabilities
- Value panel shows related data
- Generate SQL scripts for data modifications

### Schema Management

- View table definitions and properties
- Compare schemas between databases
- Generate DDL scripts
- Create and modify database objects

## Practical Applications

### Database Analysis

- Quickly understand inherited database structures
- Visualize relationships between tables
- Document database designs
- Compare schema differences

### Development Tasks

- Write and test SQL queries
- Modify data directly in the grid
- Generate scripts for deployment
- Create and modify database objects

## Conclusion

DBeaver provides a powerful, free alternative to expensive database management tools while offering features that surpass the built-in capabilities of both Access and SQL Server Management Studio. Its ability to work with multiple database platforms and create flexible ERD diagrams makes it particularly valuable for Access developers who work with various database backends.

## Recording

The full recording is available on [YouTube](https://www.youtube.com/watch?v=V03v6ZlYeBY):

## Join Live!

Want to get even more out of these presentations? Join the live Access User Group events! The next upcoming events are listed on the [AUG Event Calendar](https://accessusergroups.org/calendar/?ref=nolongerset.com).

Attending live gives you the opportunity to:

- Interact directly with presenters during Q&A sessions
- Network with other Access developers
- Share your own experiences and challenges
- Get immediate answers to your specific questions
- Participate in group discussions

With multiple user groups across different time zones (and languages!), you're sure to find a meeting time that works for your schedule.

### Acknowledgements

- *Base cover image generated by FLUX-schnell*
- *Initial draft generated by Claude-3.5-Sonnet*