SA – Database Magic Documentation

Getting Started

SA – Database Magic requires no installation. Unzip the downloaded folder anywhere on your computer and double-click SA-DB-Magic.exe to launch.

System Requirements

  • Windows 10 or Windows 11, 64-bit
  • SAM Broadcaster Pro with MySQL/MariaDB database
  • Network access to your database server

Connecting to Your Database

When you first open Database Magic you will see the Database Connection section at the top of the window.

  • Profile — type a name for this connection (e.g. “SAM Broadcaster”) so you can reload it later
  • Host — the IP address or hostname of your database server. Use 127.0.0.1 if SAM Broadcaster is on the same computer
  • Port — default is 3306 for MySQL/MariaDB
  • Database — the name of your SAM Broadcaster database (usually sam or your station name)
  • Username / Password — your database login credentials

Click the 👁 icon next to the password field to reveal your password before saving. Once you click Save Profile the password is stored and the eye icon locks for security. Click Clear Fields to wipe all credential fields if needed.

Running a Lookup

Once your connection details are entered, click Start. Database Magic will:

  1. Connect to your database
  2. Find all artists in your songlist with no website URL
  3. Look up each artist against MusicBrainz, Wikidata, Discogs, and Wikipedia simultaneously
  4. Write any verified official website URLs back to your songlist in real time

The Activity Log at the bottom of the window shows every step as it happens. Each artist is logged with the source that found their URL, or a note if no URL was found.

Stopping and Resuming

You can click Stop at any time. The current artist finishes processing and then the run pauses. Progress is saved automatically after every artist — the next time you click Start the tool picks up exactly where it left off. When a full run completes the progress file is cleared automatically.

Resetting Progress

Click Reset Progress to delete the saved progress file for the current database profile. The next run will start from the beginning and process all artists again.

Options

  • Overwrite existing entries — when checked, the tool re-processes artists that already have a website value and updates them if a better URL is found
  • Check for updates on startup — when checked, the tool silently checks for a newer version each time it opens and shows a notification banner if one is available

Multiple Database Profiles

You can save as many database profiles as you need. Each profile stores the host, port, database name, username, and password independently. To add a new profile, type a new name in the Profile dropdown, fill in the connection fields, and click Save Profile. To switch between profiles, click the Profile dropdown and select the one you want — the fields fill in automatically.

Profile settings are stored in %APPDATA%\StationAdmin\DatabaseMagic\settings.json on your computer.

How the Lookup Works

For each artist, Database Magic fires requests to four services at the same time:

  • MusicBrainz — the primary source. If an official homepage is listed in MusicBrainz it is used immediately
  • Wikidata — if MusicBrainz has a Wikidata link for the artist, Wikidata is checked for an official site property (P856)
  • Discogs — searched in parallel with MusicBrainz for artists not found there
  • Wikipedia — external links on the artist’s Wikipedia page are scanned for an official site

Social media, streaming services, and wiki links are automatically filtered out. Only genuine official artist websites are saved.

Troubleshooting

Cannot connect to database

Check that your database server is running and that the host, port, database name, username, and password are all correct. If SAM Broadcaster is on the same machine, use 127.0.0.1 as the host. The connection will time out after 10 seconds if the server cannot be reached.

Too many requests / rate limit errors

Database Magic respects the usage limits of all services it queries. MusicBrainz allows 1 request per second and Discogs allows 45 requests per minute — the tool enforces these limits automatically. If you see rate limit errors, stop the run and wait a few minutes before restarting.

Artist shows “no verified URL found”

Not every artist has an official website listed in any of the four databases. Less well-known or local artists may not have a presence in MusicBrainz, Discogs, or Wikipedia. These artists are skipped and marked as processed so they are not re-checked on the next run unless you click Reset Progress.

Updates

Database Magic is updated regularly with improvements to lookups, new features, and bug fixes. Enable Check for updates on startup in the Options section to be notified automatically, or sign up for our newsletter to get news about new tools and product changes.