WorldTree.Software

DataSpot

DataSpot is like a web browser for your database. Imagine being able to browse the data in your database like you browse the internet, without writing a single line of SQL. DataSpot uses the structure of your database to easily follow references between tables. (read more...)

Download DataSpot

Requirements

Runs on any Windows version that supports .Net 3.5 (Win7, Vista, XP, etc). At this time it only connects to SQL Server databases. Requires Microsoft .Net Framework 3.5 or later.

Note: In order for DataSpot to work right you must have database constraints defined in your database. If not it won't know how your tables are connected.

More about DataSpot

DataSpot is designed for programmers, testers, data miners, or anyone else who spends a lot of time looking through databases. In most views you can double-click on items to navigate to the item it references. Here is the list of features.

  • Tables views: list, columns, rows, record, column search
  • Stored Procedures views: list, definition, execute, search
  • Functions views: list, definition, execute, search
  • SQL Editor view: Write free form SQL queries
  • Tabbed interface so you can open multiple views at the same time
  • Back and forward buttons to navigate between views like a web browser
  • Easily create, manage, import, and export database connections
  • All results grids can be saved to a comma separated values file

Table List View

  • Shows a list of the tables in your database
  • The list filters as you type to quickly find the table you're looking for
  • Navigate directly from table list to columns, rows and record views

Table Columns View

  • Shows information about all of the columns in a table
  • Foreign key columns navigate directly to their table
  • References selector quickly navigates to any table that reference the table

Table Rows View

  • Shows a sortable list of rows in a table
  • Define a filter to search for specific rows
  • Primary key columns navigate directly to the record view of the row
  • Foreign key columns navigate directly to the referenced record
  • Foreign key columns show the referenced record in a tooltip

Table Record View

  • Shows the values in a table record sorted by column name
  • Foreign key columns navigate directly to their record
  • References selector quickly navigates to any record(s) that reference the record

Table Column Search View

  • Searches all tables for a column name
  • Wild cards allowed if you don't know the full name
  • Navigate directly from search results to columns, rows and record views

Stored Proc and Function List Views

  • Shows a list of the stored procs or functions in your database
  • The list filters as you type to quickly find the item you're looking for
  • Navigate directly from list to definition or execute views

Stored Proc and Function Definition Views

  • Shows the definition of the stored proc or function
  • Built in document search

Stored Proc and Function Execute Views

  • Executes a stored proc or function and displays the results

Stored Proc and Function Search Views

  • Search for any text in all stored procs or functions
  • Navigate directly from search results to definition or execute views

SQL Editor View

  • Write and execute free form SQL Queries
  • Built in document search
  • Save and open as text files
A